{"id":3124,"date":"2010-12-15T08:31:24","date_gmt":"2010-12-15T06:31:24","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=3124"},"modified":"2010-12-15T13:02:08","modified_gmt":"2010-12-15T11:02:08","slug":"openark-kit-rev-170-new-tools-new-functionality","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/openark-kit-rev-170-new-tools-new-functionality","title":{"rendered":"openark-kit (rev. 170): new tools, new functionality"},"content":{"rendered":"

I’m pleased to announce a new release of the openark kit<\/a>. There’s a lot of new functionality inside; following is a brief overview.<\/p>\n

The openark kit<\/em> is a set of utilities for MySQL. They solve everyday maintenance tasks, which may be complicated or time consuming to work by hand.<\/p>\n

It’s been a while since the last announced release. Most of my attention was on mycheckpoint<\/a>, building new features, writing documentation etc. However my own use of openark kit<\/em> has only increased in the past few months, and there’s new useful solutions to common problems that have been developed.<\/p>\n

I’ve used and improved many tools over this time, but doing the final cut, along with proper documentation, took some time. Anyway, here are the highlights:<\/p>\n

New tool: oak-hook-general-log<\/h4>\n

oak-hook-general-log<\/em> hooks up a MySQL server and dumps the general log based on filtering rules, applying to query role or execution plan. It is possible to only dump connect\/disconnect entries, queries which make a full table scan, or use temporary tables, or scan more than X number of rows, or…<\/p>\n

I’ll write more on this tool shortly.<\/p>\n

New tool: oak-prepare-shutdown<\/h4>\n

This tool makes for an orderly and faster shutdown by safely stopping replication, and flushing InnoDB pages to disk prior to shutting down (keeping server available for connections even while attempting to flush dirty pages to disk). A typical use case would be:<\/p>\n

\n
oak-prepare-shutdown --user=root --ask-pass --socket=\/tmp\/mysql.sock && \/etc\/init.d\/mysql stop<\/pre>\n<\/blockquote>\n
New tool: oak-repeat query<\/h4>\n
oak-repeat-query<\/em> repeats executing a given query until some condition holds. The condition can be:<\/p>\n