AMP AMP
AMP
0
AMP

How to enable the mysql slow query log?

How to enable the mysql slow query log?

MySQL Add a comment
a sample image
wilson
asked Jan 10 2019

Answer

AMP
0
AMP

By using the Following queries you can enable the Slow Query log

mysql -u root -p
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = X;
SET GLOBAL slow_query_log_file = '/path/filename';
Add a comment
a sample image
linuxhelp
asked Jan 12 2019
Post your Answer