mysql5.7質問:[Note]InnoDB:Waiting for page_cleaner to finish flushing of buffer pool

3655 ワード

mysql 5を閉じます.7の時問題を発見して、ずっと打ち固めた状態にあります
[root@localhost ~]# /etc/init.d/mysqld stop
Shutting down MySQL...............................................................................................................................................................................................................................................................................................................................................................

ログの表示
[root@localhost logs]# tail -f mysql-error.log 
2019-08-27T09:55:12.789085Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2019-08-27T09:55:12.789098Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-08-27T09:55:12.789110Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-08-27T09:55:12.789120Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2019-08-27T09:55:12.789129Z 0 [Note] Shutting down plugin 'InnoDB'
2019-08-27T09:55:12.789764Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-08-27T09:55:12.790347Z 0 [Note] InnoDB: Starting shutdown...
2019-08-27T09:55:12.892529Z 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/data/mysql/ib_buffer_pool
2019-08-27T09:55:12.893560Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190827 17:55:12
2019-08-27T09:56:14.348034Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-08-27T09:57:14.938167Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-08-27T09:58:15.580395Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-08-27T09:59:16.164504Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-08-27T10:00:16.749212Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-08-27T10:01:17.380468Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-08-27T10:02:18.073085Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

問題を探して、考えて、私はサーバーの時間を修正して、システムの時間とmysqlキャッシュの時間が一致しないようにして、私は時間を早めて、処理方法
date -s 2019-08-28 # mysql 
date -s  18:05:20

ps -ef|grep mysql #mysql

最後に通常の時間に戻せばいいです