May 25, 2012

Post: Heikki Tuuri Innodb answers - Part I

… still poking me about this I decided to publish the answers I have so far. Plus we may get some interesting follow up questions out of this. I had added my comments to some of the questions. HT will stand for Heikki Tuuri in the answers… tests by Peter Zaitsev, O_DIRECT works well to remove double buffering. In distant future, I would like to have the memlock…

Post: How Percona does a MySQL Performance Audit

Peter‘s report 6 months ago was a small encyclopedia!” The mistake here was that the consultant didn’t show all thethe following: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By default, this outputs thequestions in the comments, and I’ll try to answer