innodb_thread_concurrency，mysql lru scan depth_如何解決mysql警告：“ InnoDB：page_cleaner

我在服務器上運行了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;