Shlomi Noach is DBA,  authorized MySQL instructor software developer and Winner of the MySQL Community Member of the Year, 2009.

He has published his own collections of MySQL scripts and you might find them useful.  Shlomi calls them the “openark kit“.

The available tools are:

• oak-apply-ri: apply referential integrity on two columns with parent-child relationship.
• oak-block-account: block or release MySQL users accounts, disabling them or enabling them to login.
• oak-chunk-update: Perform long, non-blocking UPDATE/DELETE operation in auto managed small chunks.
• oak-kill-slow-queries: terminate long running queries.
• oak-modify-charset: change the character set (and collation) of a textual column.
• oak-online-alter-table: Perform a non-blocking ALTER TABLE operation.
• oak-purge-master-logs: purge master logs, depending on the state of replicating slaves.
• oak-security-audit: audit accounts, passwords, privileges and other security settings.
• oak-show-limits: show AUTO_INCREMENT “free space”.
• oak-show-replication-status: show how far behind are replicating slaves on a given master.

All tools are written in Python, and require Python 2.3 or newer, and the python-mysqldb driver. Some tools require MySQL 5.0 or higher; see the docs for each tool.

The openark kit is released under the BSD license.

Thanks Shlomi.

Enjoy!

Tweet