Hack MySQL Blog

Speaking at Percona Live MySQL Conference & Expo 2012
Fri, 27 Jan 2012 00:00:41 +0000
I’m speaking at Percona Live MySQL Conference & Expo 2012. My two talk are: Getting Started with Drizzle 7.1 and Verifying MySQL Replication Safely With pt-table-checksum 2.0. No, there’s no relationship between those topics; they’re just things I know well. I’ve been stalking Drizzle for many years. When it went GA last year, I began [...]

Databases and documentation
Sat, 12 Nov 2011 23:26:18 +0000
The MySQL documentation impresses me. I can’t recall a time when I didn’t find what I was looking for or that its details were lacking. Documenting a database server is difficult; the amount of information to organize and communicate clearly is staggering. I tasted that challenge when I helped update the Drizzle documentation, which was [...]

New algorithm for calculating 95 percentile
Tue, 30 Aug 2011 03:42:42 +0000
The 95 percentile for query response times is and old concept; Peter and Roland blogged about it in 2008. Since then, MySQL tools have calculated the 95 percentile by collecting all values, either exactly or approximately, and returning all_values[int(number_of_values * 0.95)] (that’s an extreme simplification). But recently I asked myself*: must we save all values? [...]

MySQL tools article
Mon, 01 Aug 2011 15:44:10 +0000
Although I no longer maintain hackmysql.com, I still actively develop MySQL tools. An article I wrote, 10 essential MySQL tools for admin, was published today. I hope no one’s feelings are hurt if their tool isn’t in the list, but it was rather difficult to compile the list given that so many tools are either [...]

Drizzle 7 plugins
Sun, 17 Apr 2011 21:05:23 +0000
Last week I wrote about my experience compiling Drizzle 7 on Mac OS X 10.6. Then David Shrewsbury informed me of his nearly identical blog post: Installing Drizzle from source on OS X. Once Drizzle 7 was running on my box, I immediately looked to see what plugins where available because Drizzle uses a lot [...]

MySQL Tools

In the MySQL ecosystem there is a rich jungle of tools. I stalk and observe these tools' development, having created some myself, developing others full-time, and simply being aware of others.

I maintain a list of MySQL Tools with information about the project, code, documentation and other aspects.

Documents

I write more code than docs now. I wrote these docs several years ago when I focused more on query optimization.

Indexing Basic MySQL Queries
Table Design and MySQL Index Details
MySQL ORDER BY With LIMIT and ANALYZE
How To Index For MySQL Joins
How To Look At MySQL Joins and More ORDER BY With LIMIT
Non-technical Guide to Isolating Slow MySQL Queries
COM_QUIT and Questions
DNS Details
Select and Sort Status Variables
JOIN Rows Produced vs. Rows Read
Microsecond Support for MySQL Slow Logs
MySQL Features Timeline

Friends