mysql> show variables like 'log_%';
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| log_queries_not_using_indexes | ON |
| log_slow_queries | ON |
+---------------------------------+------------------------------------------+
mysql> select version();
+------------+
| version() |
+------------+
| 5.1.45-log |
+------------+
开启慢查询,并且记录不利用索引的sql语句.
客户端执行的sql是
select * from abc where id >1 limit 10,20
在日志里变成了
select * from abc where id >N limit N,N
数字变成了N,不知道怎么回事.不知道如何解决,恢复正常.