PMM tool open table and open cache miss ratio tune

MySQL & MariaDB Other MySQL® Questions
, ,
1

Hi Percona Team,

Does i need to tune any MySQL related parameter as PMM shows below graph in red color (Percentage of open table definitions to table definition cache and open cache miss ratio)?

Percentage_of_open_table
Percentage_of_open_table892×297 28.4 KB

open_Cache_miss
open_Cache_miss896×292 29.6 KB

How to tune this?

1 Like
2

Try doubling your table_open_cache and try table_open_cache_instances=24

1 Like