__ Tables ______________________________________________________________
Open 533 of 2048 %Cache: 26.03
Opened 2.18k 0.0/s
(1) If the %Cache is inching towards 100% mark then it is good time to increase table cache value in my.cnf
table_cache = 2048
(2) Rate of opening table is another way to judge if the value of table cache needs any change. Rate of 1/s or Lower is a GOOD indicator. Anything above means - table cache needs to be increased.
No comments:
Post a Comment