How much memory does the MySQL server variable table_open_cache cause the DBMS to use?
Let's look at it from another point of view -- Is table_open_cache too big or too small?
If Table_open_cache_overflows / Uptime &gt; 1 per second, then increase the setting.
If Table_open_cache_misses / Uptime &gt; 1/sec, then increase table_open_cache
If Table_open_cache_misses / (Table_open_cache_hits + Table_open_cache_misses) &gt; 3%, then increase table_open_cacheand checktable_open_cache_instances`.