The latest from the MySQL community

I've just released updates to all the tools in the MySQL Toolkit. The biggest change I made to most packages is using DBD to read MySQL's option files, though some packages got more significant updates.

MySQL Toolkit's Show Grants tool can now separate grants into individual statements, convert them into REVOKE statements, and help you remove users from a server, even if your server doesn't support DROP USER.

MySQL Table Sync efficiently finds and resolves data (not structural) differences between two MySQL tables, which may be on different servers. It offers two search algorithms to find the rows that differ, and several methods to bring the destination table into sync with the source.

MySQL Toolkit's Show Grants tool makes it easy to extract grants from a MySQL server in canonical form. You can use it to replicate grants between servers, diff grants, and avoid spurious changesets in version control systems.

I'm continuing to add new tools to the MySQL Toolkit. MySQL Deadlock Logger is for extracting and storing information about the latest recorded InnoDB deadlock. It's not only easy to view the information from the command line, it's dead simple to store it back into a MySQL table for analysis. I think most users will find it handy to create a cron job to record the deadlocks automatically for later analysis.

I somehow introduced a syntax error into MySQL Table Checksum in the 1.0.1 release and didn't notice till just now. I've replaced the file in the Sourceforge release, but it may take a few hours for it to propagate to all mirrors. My apologies.

It's finally ready -- the new stable version of the innotop MySQL and InnoDB monitor. Version 1.4.0 brings you new features and enhancements I think you'll really enjoy.

Now that I have innotop hosted on sourceforge, I'd like to use the tools they provide, especially the forums and mailing lists. I've set up an innotop-discuss mailing list, which I hope you'll find a better way to get support than posting in the comments on this blog. I think I will close comments on all innotop-related articles I post, because I can't keep track of feedback in so many places.

I got a lot of very nice feedback on the three tools I recently added to the MySQL Toolkit project on Sourceforge, and found and solved several issues with quoting and password prompting, index types, and so forth. Thank you all for your feedback, and welcome to Ruslan Zakirov, who plans to add some new tools!

I've updated MySQL Query Profiler, which I consider the most important tool I've written. It's now included as part of the MySQL Toolkit project on Sourceforge.