I would like to enable the MySQL General Log to view all the (slow) queries. I'm using XAMPP as server and have no idea how to enable it. I can't find a good guide on the internet.
Can someone help me please?
Thanks!
logsMySQL
I would like to enable the MySQL General Log to view all the (slow) queries. I'm using XAMPP as server and have no idea how to enable it. I can't find a good guide on the internet.
Can someone help me please?
Thanks!
Best Answer
The flags you need to activate the general log and the slow on in the MySQL Documentation
I would recommend using
log-output=TABLE
It will save the logging of general log and slow log info to MySQL tables
mysql.general_log
mysql.slow_log
You should convert them to MyISAM. That way, you can index the tables by the timestamp and perform SELECT queries from them.
By default, these files use the CSV storage engine.
Convert the general log and index it by event_time:
Convert the slow log and index it by start_time:
Give it a Try !!!