Hi Richard,
The following article contains some information on how the data_engine works and some tuning options, including MySQL:
UIM Why do the UIM database tables become so fragm - CA Knowledge
Have you checked the UIM documentation on installing the product on MySQL? There's a section with parameters for large environments:
Install and Configure Your Database Software - CA Unified Infrastructure Management - 8.5.1 - CA Technologies Documentat…
And finally some documentation from dev.mysql.com on temporary tables (see excerpt after the URL):
MySQL :: MySQL 5.6 Reference Manual :: 8.4.4 Internal Temporary Table Use in MySQL
------
Internal Temporary Table Storage Engine
An internal temporary table can be held in memory and processed by the MEMORY
storage engine, or stored on disk and processed by the MyISAM
storage engine.
If an internal temporary table is created as an in-memory table but becomes too large, MySQL automatically converts it to an on-disk table. The maximum size for in-memory temporary tables is determined from whichever of the values of tmp_table_size
and max_heap_table_size
is smaller. This differs from MEMORY
tables explicitly created with CREATE TABLE
: For such tables, only the max_heap_table_size
system variable determines how large the table is permitted to grow and there is no conversion to on-disk format.
------
Please let us know whether any of the above helps.
Thanks,
Alex