Comment résoudre l'avertissement mysql: "MyISAM: page_cleaner: la boucle prévue de 1000ms a pris XXX ms. Les paramètres peuvent ne pas être optimaux "?

J'ai couru un import mysql mysql dummyctrad < dumpfile.sql sur le serveur et sa prend trop de temps pour terminer. Le fichier de vidage est d'environ 5G. Le serveur est un Centos 6, de la mémoire=16G et 8core processeurs, mysql v 5.7 x64-

Sont normales des messages et/ou le statut "en attente d'un tableau de chasse" et le message MyISAM: page_cleaner: 1000ms intended loop took 4013ms. The settings might not be optimal

mysql le contenu des journaux

2016-12-13T10:51:39.909382Z 0 [Note] MyISAM: 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] MyISAM: 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] MyISAM: 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)

Processlist:

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)

Mise à jour-1

mysqlforum ,innodb_lru_scan_depth

changer innodb_lru_scan_depth valeur de 256 ont amélioré le temps d'exécution des requêtes de type insert + pas de message d'avertissement dans le journal, le défaut était innodb_lru_scan_depth=1024;

SET GLOBAL innodb_lru_scan_depth=256;

source d'informationauteur satch_boogie | 2016-12-14