A colleague pointed me at More fun with the MySQL Audit Plugin API which looks very interesting. Analysis of the queries going on inside a msyqld has been something that has been wanted for some time. Until now it’s only been possible with external addons such as MySQL Enterprise Monitor which do a good job. However, really the place for this functionality is inside the db server itself. If 5.5 m3 provides the hooks to do this that’s great news and while Anders’ first implementation may be simple, this can surely be extended in many ways.
The things I would like to see added to this plugin are the following many of which are safeguards to ensure you can use functionality on a system like this in production without …[Read more]