Technologies/MySQL/mysql.performance.opened_tables
MySQLMySQLMetric

mysql.performance.opened_tables

The number of tables that have been opened. If `opened_tables` is big, your `table_open_cache` value is probably too small.
Dimensions:None
Available on:DatadogDatadog (1)
Interface Metrics (1)
DatadogDatadog
The number of tables that have been opened. If `opened_tables` is big, your `table_open_cache` value is probably too small.
Dimensions:None
Sources
mysql.performance.opened_tablesgithub.com
Related Insights (1)
Open Table Cache Thrashinginfo

Table cache insufficient for working set, causing frequent table opens/closes. High table cache miss rate degrades performance as MySQL repeatedly opens/closes table files, consuming CPU and causing latency spikes.

▸