…MySQL‘s key cache hit ratio is wrong, even when you hear it from experts. There are two major problems with the key buffer hit ratio…How to choose a key_buffer_size Let’s recap. So far I’ve shown you the fallacy of tuning by ratio…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…to grow dramatically do not oversize innodb_buffer_pool_size you might find…to 512M normally make sense. Check it however after a while and see if it is well used. For certain workloads cache hit ratio…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…and how to use this info to improve MySQL Performance. To… need to look at the log files to find…to ensure data makes it to the disk – just passing it to OS cache…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…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…to contain the following: #!/bin/bash while [ 1 ] do ./worker >> /dev/null 2>&1 < /dev/null done; Where to find…ratio(compared to Innodb, 8:1 compared to…mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…finding their data in buffer pool so they start to compete on hot latches and performance go down. Now back to original question – how…to. Using this approach you also should be careful with your estimations and take IO subsystem into account – even with same cache hit ratio…
