如何在不重新启动MySQL的情况下启用MySQL的慢查询日志? [英] How can I enable MySQL's slow query log without restarting MySQL?

问题描述

我按照此处的说明进行操作:解决方案

尝试SET GLOBAL slow_query_log = 'ON';甚至FLUSH LOGS;

这假设您使用的是MySQL 5.1或更高版本.如果使用的是较早版本，则需要重新启动服务器. MySQL手册中对此进行了说明.您可以在配置文件或命令行中配置日志.

I followed the instructions here: http://crazytoon.com/2007/07/23/mysql-changing-runtime-variables-with-out-restarting-mysql-server/ but that seems to only set the threshold.

Do I need to do anything else like set the filepath?

According to MySQL's docs

If no file_name value is given for --log-slow-queries, the default name is 
host_name-slow.log. The server creates the file in the data directory unless 
an absolute path name is given to specify a different directory. 

Running

SHOW VARIABLES

doesn't indicate any log file path and I don't see any slow query log file on my server...

EDIT

Looks like I'm using server version 5.0.77, so I needed to do:

SET GLOBAL log_slow_queries = 1;

but I get: ERROR 1238 (HY000): Variable 'log_slow_queries' is a read only variable

I assume I'm going to need to restart the server and have log_slow_queries set in my config?

解决方案

Try SET GLOBAL slow_query_log = 'ON'; and perhaps FLUSH LOGS;

This assumes you are using MySQL 5.1 or later. If you are using an earlier version, you'll need to restart the server. This is documented in the MySQL Manual. You can configure the log either in the config file or on the command line.

这篇关于如何在不重新启动MySQL的情况下启用MySQL的慢查询日志?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！