log-show-queries=/var/lib/mysql/mysql_logs/show.log
long_query_time=1
log-queries-not-using-indexs我在mysql配置了这些选项,可以启动的时候报错,我去错误日志中看到2013-05-09 20:43:36 12282 [ERROR] /usr/sbin/mysqld: unknown variable 'log-show-queries=/var/lib/mysql/mysql_logs/show.log'
2013-05-09 20:43:36 12282 [ERROR] Aborting请问log-show-queries有问题吗?
long_query_time=1
log-queries-not-using-indexs我在mysql配置了这些选项,可以启动的时候报错,我去错误日志中看到2013-05-09 20:43:36 12282 [ERROR] /usr/sbin/mysqld: unknown variable 'log-show-queries=/var/lib/mysql/mysql_logs/show.log'
2013-05-09 20:43:36 12282 [ERROR] Aborting请问log-show-queries有问题吗?
log-slow-queries
2013-05-09 22:58:23 13835 [ERROR] Aborting我改过来了,可是还是报这个错误
my.cnf配置如下:
log-slow-queries=/var/lib/mysql/mysql_logs/slow.log
long_query_time=1
log-queries-not-using-indexs
改这句为:
slow-query-log-file=/var/lib/mysql/mysql_logs/slow.log应该是因为你的mysql版本为5.6以上吧?