mysql 满日志不记录_mysql 慢查询日志记录不慢的查询？

mysql 设置慢查询开启后，在慢日志里记录大量SQL，因没有对外服务访问，所以很诡异，查看发现是metric mysql_exporter产生的查询。但查看每条慢查询执行时间都非常短。因为大量写入所以帮看下是什么原因导致。

mysqldumpslow 命令生成的统计如下：

Reading mysql slow query log from mysqld.log

Count: 1185  Time=0.00s (0s)  Lock=0.00s (0s)  Rows_sent=5.0 (5925), Rows_examined=5.0 (5925), Rows_affected=0.0 (0), root[root]@[127.0.0.1]

SELECT

page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time

FROM information_schema.innodb_cmp

Count: 1185  Time=0.00s (0s)  Lock=0.00s (0s)  Rows_sent=5.0 (5925), Rows_examined=5.0 (5925), Rows_affected=0.0 (0), root[root]@[127.0.0.1]

SELECT

page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time

FROM information_schema.innodb_cmpmem