Sometimes, you need to figure out which request comes from cms / cmf or another script to the Mysql server.
For example, I had to deal with the jqgrid-php library. It was unclear which query comes to the mysql server from the script.
You can, of course, install and configure mysql-proxy, but there is a simpler solution:
1. Login to Mysql-server as mysql admin (root) user.
2. Set where to write the log:
set global general_log_file='/tmp/mysql_query.log';
3. Enable log:
set global general_log = 1;
4. Run your scripts
5. Turn it off so it does not clog the server
set global general_log = 0;
6. Analyze the log:
less /tmp/mysql_query.log
7. it’s all!
Post a comment