不解的mysql slow log 配置

ytjwt

1：首先配置如下
log_slow_queries       = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

有如下警告

100510  2:42:59 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.


2：这次把log_slow_queries    换成slow_query_log
slow_query_log          = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

换成slow_query_log，也有警告
100510  2:45:30 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set


那我如果想启动log-queries-not-using-indexes，且不希望有警告，该怎么办？

yueliangdao0608

把你的配置全部贴出来。 有的配置选项已经过期了。

yueliangdao0608

SLOW LOG,目前整的挺复杂的，因为版本的不同，写法会不同。所以你先确定你的版本是什么再说。

1. Control the slow query log as follows:
   
2. 
   
3.     *
   
4. 
   
5.       Before 5.1.6, the slow query log destination is always a file. To enable the log, start mysqld with the --log-slow-queries[=file_name] option.
   
6.     *
   
7. 
   
8.       As of MySQL 5.1.6, the destination can be a file or a table, or both. Start mysqld with the --log-slow-queries[=file_name] option to enable the slow query log, and optionally use --log-output to specify the log destination (as described in Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”).
   
9.     *
   
10. 
    
11.       As of MySQL 5.1.12, as an alternative to --log-slow-queries, use --slow_query_log[={0|1}] to specify the initial slow query log state. In this case, the default slow query log file name is used. With no argument or an argument of 1, --slow_query_log enables the log. With an argument of 0, this option disables the log.
    
12.     *
    
13. 
    
14.       As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and optionally --slow_query_log_file=file_name to specify a log file name. The --log-slow-queries option is deprecated.
    

复制代码

ytjwt

谢谢上帝他爷，解决了
As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and optionally --slow_query_log_file=file_name to specify a log file name. The --log-slow-queries option is deprecated.


slow_query_log=1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

这样就不会有警告了，

ruochen

笔记一下