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 lua script to use with mysql-proxy
- loadTrace.sh, which is a shell script that will load the output of mysql-proxy into the analysis tables. This creates the __perf database and the proper analysis table if needed. THIS LOOKS FOR trace.log IN THE CURRENT DIRECTORY. yeah yeah, it could take the name as an argument, but this is not intended as a package, it’s just an example for you to follow.
Remember to save the output of mysql-proxy in order to load it later with loadTrace.sh (i.e., run something like mysql-proxy –proxy-lua-script=/path/to/trace.lua > trace.log and then loadTrace.sh
Related posts:
- Using MySQL Proxy to benchmark query performance By transparently sitting between client and server on each request,...
- New release of MySQL Proxy GPL MySQL Proxy has a new release, just three days ago,...
- MySQL Certification self study I’m taking the MySQL Certification exams soon, and while I’d...
- High Availability MySQL Cookbook review High Availability MySQL Cookbook (Alex Davies, Packt Publishing) presents different...
- Using MySQL sandbox for testing MySQL Sandbox is a great tool for quickly deploying test...
Related posts brought to you by Yet Another Related Posts Plugin.
Topics:
MySQL |
No Comments »