Monitor all MySQL execution statements

Sometimes we use the PHP framework and the ready-made ORM to save the trouble of writing SQL, but we want to see which sqls have been generated. Or we have downloaded WordPress or druapl, I want to see how my SQL is written. If I can monitor every step of MySQL, it's not difficult. I just need to configure it a little and add a tool.


First, open % mysqldir % My. ini (My. CnF in Linux) and add this sentence.

1. # Specify the log location 2. Log = C:/appserv/MySQL. Log 3. # Or log =/in Linux/ VaR /Log/MySQL. Log

In this way, MySQL will write all operation records in the mysql. log file.