Updated mysql-proxy benchmarking script (for proxy 0.7)
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 following: trace.lua, which is the [...]
Using MySQL Proxy to benchmark query performance
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 some stats on the queries [...]