How to Enable Slow Query Log in MySQL 5.6

最新推荐文章于 2023-06-02 11:32:28 发布

转载最新推荐文章于 2023-06-02 11:32:28 发布 · 345 阅读

本文介绍如何在MySQL5.6中快速且正确地启用慢查询日志功能，这对于排查应用性能问题非常有用。文章详细说明了通过编辑my.cnf文件来设置long_query_time、slow_query_log及slow_query_log_file参数的方法，并提供了重启MySQL服务的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

How to Enable Slow Query Log in MySQL 5.6

Add Comment

by Santosh Prasad

Compared to previous version in MySQL 5.6 they introduced different way for logging slow queries.

In this article I will show you to quickly and correctly enable the slow query log in MySQL 5.6 which is extremely useful for debugging application performance issues.

Enable Slow Query Log in MySQL 5.6

Follow the below steps to enable slow query log in MySQL 5.6.

1. Login to your MySQL server.

2. Open the my.cnf file in your favourite test editor.

# vim /etc/my.cnf

Add the following line in:

long_query_time=1
slow_query_log=1
slow_query_log_file="/var/log/mysql/log-slow-queries.log"

Where;

long_query_time – Defines the minimum threshold for the “slow query” designation.

1 means log all queries that take more than 1s to execute slow_query_log – Value of 1 means enable. 0 means disable slow_query_log_file – Log file path. This path generally be at the same location as mysql-error.log

3. Reload the MySQL server it will not cause an interruption.