mysql lru scan depth_如何解决mysql警告：“ InnoDB：page_cleaner：1000毫秒的预期循环用了XXX毫秒。设置可能不是最佳的”？...

我在服务器上运行了mysql import mysql dummyctrad

x64-

这些是正常消息/状态“正在等待表刷新”吗？ InnoDB: page_cleaner: 1000ms intended loop took 4013ms.

The settings might not be optimal

mysql日志内容

2016-12-13T10:51:39.909382Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4013ms. The settings might not be optimal. (flushed=1438 and evicted=0, during the time.)

2016-12-13T10:53:01.170388Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4055ms. The settings might not be optimal. (flushed=1412 and evicted=0, during the time.)

2016-12-13T11:07:11.728812Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4008ms. The settings might not be optimal. (flushed=1414 and evicted=0, during the time.)

2016-12-13T11:39:54.257618Z 3274915 [Note] Aborted connection 3274915 to db: 'dummyctrad' user: 'root' host: 'localhost' (Got an error writing communication packets)

流程清单：

mysql> show processlist \G;

*************************** 1. row ***************************

Id: 3273081

User: root

Host: localhost

db: dummyctrad

Command: Field List

Time: 7580

State: Waiting for table flush

Info:

*************************** 2. row ***************************

Id: 3274915

User: root

Host: localhost

db: dummyctrad

Command: Query

Time: 2

State: update

Info: INSERT INTO `radacct` VALUES (351318325,'kxid ge:7186','abcxyz5976c','user100

*************************** 3. row ***************************

Id: 3291591

User: root

Host: localhost

db: NULL

Command: Query

Time: 0

State: starting

Info: show processlist

*************************** 4. row ***************************

Id: 3291657

User: remoteuser

Host: portal.example.com:32800

db: ctradius

Command: Sleep

Time: 2

State:

Info: NULL

4 rows in set (0.00 sec)

更新1

将innodb_lru_scan_depth值更改为256可改善插入查询的执行时间+日志中无警告消息，默认值为innodb_lru_scan_depth =

1024;

SET GLOBAL innodb_lru_scan_depth=256;