You are here
Table definition cache too small
The number of table definitions (SHOW CREATE TABLE\G
) that can be stored in the table definition cache (table_definition_cache
). If you have a large number of tables (> 400) in your database instance, you should consider a larger table definition cache to increase your database throughput and decrease your query latency.
The command SELECT COUNT(*) FROM information_schema.tables;
shows you how many tables and thus table definitions you have. The global status Open_table_definitions
is the current amount of open table definitions.
For further information consult the documentation of MariaDB and MySQL.
Good values for the table_definition_cache
are between 400 and 2000. A bigger table definition cache also means that your database uses more memory (RAM)!