Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The method of opening slow query Log on mysql Command Line

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 204

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report