Search This Blog

Thursday, December 2, 2010

Table Cache - Mysql Server - Performance Tunning

One of the many important parameter is table cache

__ 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