You are here

Table definition cache too small

The number of table definitions (from .frm files) that can be stored in the definition cache (table_definition_cache). If you use a large number of tables, you can create a large table definition cache to speed up opening of tables.
The command SELECT COUNT(*) FROM information_schema.tables; shows you roughly how many table definitions you have. Open_table_definitions is the current amount of open table definitions. For further information look here: Table Defintion Cache.