content_image/779961.jpg content_image/779970.jpg content_image/779969.jpg
<img src='content_image/779961.jpg'>

Defines a limit for the number of tablespace definition objects, both used and unused, that can be kept in the dictionary object cache. 

Unused tablespace definition objects are only kept in the dictionary object cache when the number in use is less than the capacity defined by tablespace_definition_cache . 

A setting of 0  means that tablespace definition objects are only kept in the dictionary object cache while they are in use. 

For more information, see Section 14.4, “Dictionary Object Cache” . 

• temptable_max_mmap 

<img src='content_image/779970.jpg'>

Defines the maximum amount of memory (in bytes) the TempTable storage engine is permitted to allocate from memory-mapped temporary files before it starts storing data to InnoDB  internal temporary tables on disk. A setting of 0 disables allocation of memory from memory-mapped temporary files. For more information, see Section 8.4.4, “Internal Temporary Table Use in MySQL” . 

• temptable_max_ram 

<img src='content_image/779969.jpg'>

