My previous post explored a stored procedure that extended procedure_analyse with the intent of helping DBAs optimize table structure. Here's an improved version. I've followed Arjen Lentz's suggestion and added support for the max_elements and max_memory parameters. I also added a new Indexed column to the output, which is an...

SELECT Field0[,Field1,Field2,...] FROM TABLE PROCEDURE ANALYSE() is a nice tool to find out more about your table's columns. Still, it could be improved in a lot of ways, and the stored procedure below is a starting point. It makes use of procedure analyse (though with 'SELECT * FROM'), and modifies...

My previous post contained a lua script for MySQL proxy that would generate benchmarking information. However, just days (or maybe hours?) after I published it, release 0.7 of mysql-proxy was published, making my script obsolete. I've fixed this (it needed just a minor tweak), so here's a tarball with the...

By transparently sitting between client and server on each request, MySQL Proxy offers many possibilities for query manipulation. Many are explored in the cookbook, and they even include a histogram recipe. Still, I wanted to learn more about the proxy while working on a script that would let me get...

MySQL Sandbox is a great tool for quickly deploying test MySQL instances, particularly if your daily work involves diagnosing problems across multiple MySQL versions. Once you've downloaded it, it needs no installation. Just have a few MySQL binary releases at hand, and begin creating sandboxes in just a few seconds:...