… 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when…cache interchangeably. However, I will be careful about the difference between “rate” and “ratio”. In this article, the key cache miss rate…query I know is slow and is a problem for my application. I have profiled it with SHOW…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
…single operation may be IO bould while showing very large hit rate so even taking data for single …OS or SAN cache hit rate – something you would not see otherwise. The bad luck is – MySQL currently does not… example if single query is issuing 100+ random IO requests which are not cached by OS or …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…queries as if query cache hit happens Com_select is not incremented. But if you have just 20% Cache hit rate…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL… writes are done to OS cache, and being sequential writes these … with hit rate of 995/1000. ————– ROW OPERATIONS ————– 0 queries inside InnoDB, 0 queries …
Comment: Opening Tables scalability
December 22, 2006 By 27 Comments
…good hit rate): root@titanic [/var/lib/mysql]# ls -la|wc -l 24547 root@titanic [/var/lib/mysql]# …c 1797812 4.7030 mysqld Query_cache::insert_into_free_memory_list(Query_cache_block*) 1685928 4…. cpu time. That’s after fixing show databases problem, with show databases the number would be more …
Post: Living with backups
November 6, 2008 By 28 Comments
…your favorite website can still show up in the browser. Moreover…reason. Since the hit ratio becomes worse as the cache is being …MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries…tar –read-rate=15000000 -C /mnt/snapshot -c -z -v -f – mysql | ssh…
