I’m further developing a general log hook, which can stream queries from the general log. A particular direction I’m taking is to filter queries by their type of actions. For example, the tool (oak-hook-general-log) can be instructed to only stream out those queries which involve creation of a temporary table; or those which cause for [...]
I’m seeking input on a new openark kit utility I’ve started to implement. The tool, oak-hook-general-log, will hook up to a MySQL (>= 5.1) server, and stream the general log into standard output. It looks like this: bash$ python src/oak/oak-hook-general-log.py –socket=/tmp/mysql.sock –user=root 2010-03-21 10:18:42 root[root] @ localhost [] 79 1 Query SELECT COUNT(*) FROM City [...]
In response to Mark Callaghan’s post mk-schema-change. I apologize for not commenting on the post itself, I do not hold a Facebook account. Anyway this is a long write, so it may as well deserve a post of its own. Some of the work Mark is describing already exists under openark kit‘s oak-online-alter-table. Allow me [...]
Thanks to Lenz Grimmer, openark kit is now available in RPM format. .DEB or python packages are available, as usual, on project page on Google Code. Thank you, Lenz!
A new release of openark kit is out. Some interesting additions.changes are: oak-online-alter-table: now works with multicolumn UNIQUE KEYs New: oak-chunk-update: break an long running or non indexed UPDATE/DELETE to small chunks oak-purge-master-logs, oak-show-replication-status: support for non standard slave ports openark kit is a set of utilities for MySQL, helping in easing out everyday’s work. [...]
A new utility in openark kit allows for online ALTER TABLE operation. That is, the modification of table structure without locking down the entire table for the duration of the operation. The oak-online-alter-table utility works under the following restrictions: The table has at least one single-column UNIQUE KEY [*] Altered table shares a single-column UNIQUE [...]
A long time missing feature in MySQL is temporarily blocking accounts: denying a user to log in, without affecting any other of her privileges. There is no such privilege as ‘LOGIN’ in the grants table, as the ability to log in is the most basic one MySQL allows. This basic privilege is called USAGE. I’ll [...]
It is my great pleasure to announce the availability of the openark kit, a set of lightweight utilities for MySQL, which eases every day tasks. 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-kill-slow-queries: terminate [...]