1.

Default time to log a query in slow query log and can we change that in MySQL?

Answer»

Default time to log a query in slow query log and can we CHANGE that in MySQL?
YES, we can change the default time to log a query in MySQL. By default it will take more then 10 seconds to run. We can change this interval. And below is the command to change the time:-
SET GLOBAL long_query_time = n;
In above command we can PUT number in place of n to set the time to log query in slow query log.



Discussion

No Comment Found