Bits and pieces of John Dalton from all over your internet. - tagged with tuning

How well does your table fit in innodb buffer pool?

Sun, 18 Sep 2011 06:32:00 -0500

How well does your table fit in innodb buffer pool?

Fri, 16 Sep 2011 00:29:00 -0500

Performance Tuning flowchart for MySQL

Tue, 21 Sep 2010 05:39:00 -0500

Not presented as a flowchart, but that's what it feels like to me. A great step-by-step breakdown of tuning MySQL (including consideration of architecture, application and OS.)

Michael Caplan / Blog / Don't Forget to Flush

Wed, 03 Mar 2010 23:03:00 -0600

An excellent article explaining the benefits of prematurely flushing the first part of the web server's response, in particular the page headers. Discusses chunked encoding and content compression as well.

MySQLTuner

Mon, 23 Mar 2009 21:20:00 -0500

Cool script, and coolest domain name/installation method in the world.

mysqlsla :: Parse, filter and sort MySQL slow, general and binary logs

Wed, 10 Dec 2008 19:40:00 -0600

An alternative to the MySQL Query Analyzer at Xaprb

Wed, 10 Dec 2008 19:28:00 -0600

Article suggesting that percona patched MySQL builds combined with mysqlsla are a better option than the MySQL Query Analyzer (proprietary, only available with a MySQL Enterprise subscription).

Mysql query analyzer uses mysql proxy underneath, which is a great thing in its own right.