慢查询是开启的:mysql>showvariableslike'%slow%';+---------------------------+-------------------------------------+|Variable_name|Value|+---------------------------+-----...
慢查询是开启的:
mysql> show variables like '%slow%';
+---------------------------+-------------------------------------+
| Variable_name | Value |
+---------------------------+-------------------------------------+
| log_slow_admin_statements | OFF |
| log_slow_slave_statements | OFF |
| slow_launch_time | 1 |
| slow_query_log | ON |
| slow_query_log_file | /data/eh/mysql5/data/mysql-slow.log |
+---------------------------+-------------------------------------+
日志权限如下:
-rw-rw---- 1 mysql mysql 549 Oct 13 19:32 /data/eh/mysql5/data/mysql-slow.log
mysql慢查询日志中只有:
/data/eh/mysql5/bin/mysqld, Version: 5.6.12-log (MySQL Community Server (GPL)). started with:
Tcp port: 3341 Unix socket: /tmp/mysql.sock
Time Id Command Argument
以上就是现在的情况 ,mysql没有向日志记录其他信息,重启mysql一样没有用,可以确定存在性能恶劣的sql,查询时间一定大于1,向专业人士请助!
在线等
展开