Note: Slow queries can affect database performance and overall server performance.
In order to deactivate it:
- Connect to the MySQL database.
Type the following commands at the mysql> prompt:
SET GLOBAL slow_query_log = 'OFF';
Exit from the MySQL prompt and restart MySQL.
Additional Options that can be set:
- SET GLOBAL long_query_time = X;
By default 10 seconds. Change it to log queries that last more than a specific time.
- SET GLOBAL slow_query_log_file = '/path/filename';
Change the log path or filename.
I hope this information is useful for you. If you have any other questions, please do not hesitate to let us know.