May 22, 2012

Post: Why you should ignore MySQL's key cache hit ratio

the cache; it is a dimensionless number because the units are the same in the numerator and denominator, and they cancel out. The key cache hit ratio is simply one minus the miss ratio. The key_buffer hit ratio The

Post: What to tune in MySQL Server after installation

MySQL DBAs or be involved with MySQLkey_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both data andand see if it is well used. For certain workloads cache hit ratio

Post: SHOW INNODB STATUS walk through

the buffer pool. Finally you can see buffer pool hit ratio which measures buffer pool efficiency. 1000/1000 corresponds to 100% hit rate. It is hard to tell what buffer pool hit