Jeremy Zawodny's MySQL Stuff

A collection of stuff I've done that's related to MySQL, a fast and reliable Open Source Relational Database Server.


I occasionally (as time permits) help out companies with their MySQL needs. I specialize in performance tuning and replication but can handle nearly all aspects of MySQL on Linux/Unix systems. Here are some of my current and past clients.

Contact me for rates and availability.


Here's a brief listing of the MySQL related tools I've built. Click on the links for more detailed pages, downloads, and so on.

A clone of the top program which can be used to monitor what your MySQL server is doing. It lists active threads (which you can filter and even kill), performance statistics, and more.

For MySQL 3.23.xx, setting up replication can be a pain because you need to generate an initial (consistent) snapshot of your data to load onto your slave(s). You also need to make sure the binary log on the master reflects the exact time at which you took the snapshot. mysqlsnapshot automates the process.

mysqlsnapshot is also a great alternative to mysqlhotcopy for performing backups of a live MySQL server. mysqlsnapshot used to be known as myrepl, but this is a more descriptive name.

Super Smack
A a benchmarking, stress testing, and load generation tool for MySQL developed by Sasha Pachev but hosted here and featured in chapter 3 (Benchmarking) of High Performance MySQL.

Spice up your .sig file with a single line of performance stats about your favorite MySQL server. You can use it to brag... Or get past the SPAM filter on the MySQL mailing lists... Or just for the heck of it.

A DBI wrapper from MySQL to Do What I Want (DWIW). This was developed during my day job (Yahoo Finance at the time). It is described in my "Building Maintainable and Fault Tolerant MySQL Applications with Perl" presentation.


Here's a list of the stuff I've written about MySQL.

Pre-order High Performance MySQL from The book I've been hacking at off and on for 2 years is nearly complete! You can pre-order today from and be one of the first kids on the block with a copy.

There will also be a companion web site launching in January 2004.

What's New in MySQL 4.0
An overview of major new features in 4.0 and a peek ahead to version 4.1. Published in the September 2002 issue of Linux Magazine.

MySQL Administration Made Easy
A review of PHPMyAdmin in the July 2002 issue of Linux Magazine.

MySQL Performance Tuning: Making sure your MySQL server flies
Published in the December 2001 issue of Linux Magazine. This article covers server-side tuning of MySQL's various buffers and caches.

MySQL Performance Tuning: How to Write Efficient MySQL Applications
Published in the June 2000 issue of Linux Magazine. This article covers basic application design and optimization techniques.


Here's a list of the presentations I've written about MySQL, listed from newest to oldest..

Scaling MySQL and PHP
Presented on Thursday, October 24th, at the 2002 PHP Conference in Milbrae, CA. The presentation was 90 minutes long.

Managing MySQL Replication
Presented on Friday, July 26th at the 2002 O'Reilly Open Source Convention in San Diego, CA. The presentation lasted 90 minutes.

MySQL Backup and Recovery
Presented on Wednesday, July 24th at the 2002 O'Reilly Open Source Convention in San Diego, CA. The presentation lasted 45 minutes.

MySQL Optimization
Presented on Monday, July 22nd at the 2002 O'Reilly Open Source Convention in San Diego, CA. The presentation lasted 3 hours (180 minutes).

What's new in MySQL 4.0
Presented at a Yahoo Engineering talk on Thursday, June 20th 2002. It covers MySQL 4.0's major new features and enhancements. It also briefly touches on what's coming in 4.1 and beyond. Some of the material isn't terribly useful without the audio (me) that goes with it. But someone might find it useful. There's little if anything that's Yahoo-specific in it.

Perl & MySQL in Yahoo! Finance
Presented at the Silicon Valley Perl Mongers on June 4th, 2002. This is a revised and updated version of the previous presentation. It covers the recent additions to DBIx::DWIW and goes a bit more in-depth on the Perl side of things.

Building Maintainable and Fault Tolerant MySQL Applications with Perl
This was my presentation at the 2nd annual Open Source Database Summit (OSDS) in Providence, Rhode Island in September of 2001.

Copyright 2003, Jeremy D. Zawodny <>

Site built with Emacs, MySQL, HTML::Mason and some random Perl code on my Linux box.

Need books or CDs? Try and help to fund my collection.