The method of opening slow query Log on mysql Command Line

This article is about how to open the slow query log on the mysql command line. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The mysql command line can open the slow log by executing the [set global slow_query_log='ON';] statement. You can check whether the slow log is open by executing the [show variables like "% slow%";] statement.

Specific methods:

Check the default slow query time of 10 seconds.

Mysql > show variables like "long%" +-+-+ | Variable_name | Value | +-+-+ | long_query_time | 10.000000 | +-+-+ 1 row in set (10.000000 sec)

Set it to 3 seconds, add global, and exit will take effect again.

Mysql > set global long_query_time=3; Query OK, 0 rows affected (0.00 sec)

Check to see if the slow query is enabled.

Mysql > show variables like "slow%" +-+ | Variable_name | Value | +-+- -+ | log_slow_queries | OFF | | slow_launch_time | 2 | slow_query_log | OFF | | slow_query_log_file | / usr/local/mysql/mysql-slow.log | +- -+-+ 4 rows in set (0.00 sec)

Enable slow query

Mysql > set global slow_query_log='ON'; Query OK, 0 rows affected (0.28 sec)

Check to see if it is turned on

Mysql > show variables like "slow%" +-+ | Variable_name | Value | +-+- -+ | log_slow_queries | ON | | slow_launch_time | 2 | slow_query_log | ON | | slow_query_log_file | / usr/local/mysql/mysql-slow.log | +- -+-- + 4 rows in set (0.00 sec) Thank you for reading! On the mysql command line to open the slow query log method to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.