Version 1.4.3 of the innotop MySQL and InnoDB monitor is out. This release fixes some minor bugs and feature annoyances, and at last innotop has thorough documentation, available online!

In the first two articles in this series, I discussed archiving basics, relationships and dependencies, and specific archiving techniques for online transaction processing (OLTP) database servers. This article covers how to move the data from the OLTP source to the archive destination, what the archive destination might look like, and how to un-archive data. If you can un-archive easily and reliably, a whole new world of possibilities opens up.

One very interesting thing I noticed with MySQL was that if you delete a database, ibdata file doesn’t shrink by that much space to minimize disk usage. I deleted the database and checked usage of /usr/local/mysql/var folder and noticed that ibdata file is still the same size. So the problem I face now [...]

Hey look! CIA uses MySQL:

http://cia.navi.cx/info

I just returned home after attending the International PHP Conference 2004 and MySQL ComCon Europe 2004 conferences.

Monday
After a convenient ride with the ICE-3 high-speed train from Siegburg to Frankfurt am Main / Airport (about 40 minutes) and a short ride with a shuttle bus to the hotel (about 10 minutes) I arrived at the conference venue just in time for the first coffee break of the day.

Following the first "Hello!"s with my fellow PHP developers …