Clever Geek Handbook

Track all Mysql queries in WAMP

I want to track how long it takes to complete my requests I have linked to this post but I only get requests without time. Perhaps after using my web app for wile using select, update, insert query (not from the console, but while executing a real web app) I can get a summary like this output generated by SHOW PROFILES; ... I am working with wamp mysql V5.5.24 Thanks a lot

Edit: I used triggers to track the update and insert statement after this method I still have a problem how to track the query selection. any idea please?

+3


source to share


3 answers


It doesn't work anymore.

As of July 2013, you need:



general-log=1
general-log-file = "C:\wamp\logs\mysql_general.log"
+5


source


Are you sure you are not running out of time in the slow query log ?



If you just want to optimize your queries (instead of checking the execution time of each one), you can see the state of the mysql server in phpmyadmin (assuming you saved it to your server) as described here . The full tutorial is paid, but a preview will take you to the server status page where phpmyadmin will point out the problem areas for you.

+1


source


Finally, I used the general log by installing the WAMP server as follows

[mysqld]
 port=3306
 long_query_time = 1
 slow_query_log = 1
 slow_query_log_file = "E:/wamp/logs/slowquery.log"
 log = "E:/wamp/logs/genquery.log"

after that i used this tool (trial) dbForge Studio where i can use the query profiler and i get the full runtime.

+1


source






More articles:


All Articles