Have you ever wanted a handy reference of all of the various variables available in MySQL Proxy?
I’ve written a Lua script that outputs many of the available variables, which is really useful for coding Lua scripts for MySQL Proxy. In addition to the variables, it also generates output during each main function it enters in the Proxy, so you can follow the execution trace, and then see the value of each variable when it is within a particular function.
I’ve tested this on MySQL Proxy 0.7.2 and the newly available Proxy 0.8.0.
Here is a sample of the output, where I just connect, and then issue a simple query (SELECT * FROM world.city LIMIT 1):
C:Program FilesMySQLmysql-proxy-0.8.0bin>mysql-proxy.exe --proxy-lua-script=show-vars.lua /* Entering function connect_server() */ When the proxy accepts a connection from a …[Read more]