May 26, 2012

Post: MySQL Query Cache

MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Queryqueries is small so cache duplication is not the problem. Finally I do not want to hack wordpress

Post: Advanced index analysis with mk-index-usage

query 7675136724153707161, anyway? mysql> select * from queries where query_id = 7675136724153707161\G *************************** 1. row *************************** query_id: 7675136724153707161 fingerprint: select * from wp_comments where comment_post_id = ? and comment