【MySQL】[Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
xixuefeng
MySQL
2020-01-20 8:52:05
2,824 次浏览
【MySQL】[Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool已关闭评论
好多人应该都遇到过类似如下问题
1 2 3 4 5 6 7 8 9 10 11 |
[root@msp ~]# service mysql stop Shutting down MySQL....................................................................... .......................................................................................... .......................................................................................... .......................................................................................... .......................................................................................... .......................................................................................... .......................................................................................... .......................................................................................... .......................................................................................... ................... |
关闭MySQL服务时,长时间等待也关闭不了。此时查看日志,如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
[root@msp ~]# tail -100f /data/db/mysql/3306/mariadb.log 2020-01-19T02:53:12.538553Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-01-19T02:53:12.539475Z 0 [Note] Binlog end 2020-01-19T02:53:12.545721Z 0 [Note] Shutting down plugin 'ngram' 2020-01-19T02:53:12.545740Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-01-19T02:53:12.545744Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-01-19T02:53:12.545745Z 0 [Note] Shutting down plugin 'partition' 2020-01-19T02:53:12.545746Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-01-19T02:53:12.545748Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-01-19T02:53:12.545749Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-01-19T02:53:12.545751Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-01-19T02:53:12.545752Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-01-19T02:53:12.545753Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-01-19T02:53:12.545754Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-01-19T02:53:12.545756Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-01-19T02:53:12.545757Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-01-19T02:53:12.545758Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-01-19T02:53:12.545759Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-01-19T02:53:12.545760Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-01-19T02:53:12.545762Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-01-19T02:53:12.545763Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-01-19T02:53:12.545764Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-01-19T02:53:12.545765Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-01-19T02:53:12.545767Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-01-19T02:53:12.545768Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-01-19T02:53:12.545769Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-01-19T02:53:12.545770Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-01-19T02:53:12.545771Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-01-19T02:53:12.545773Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-01-19T02:53:12.545774Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-01-19T02:53:12.545775Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-01-19T02:53:12.545776Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-01-19T02:53:12.545778Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-01-19T02:53:12.545779Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-01-19T02:53:12.545780Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-01-19T02:53:12.545781Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-01-19T02:53:12.545782Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-01-19T02:53:12.545784Z 0 [Note] Shutting down plugin 'InnoDB' 2020-01-19T02:53:12.545819Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-01-19T02:53:12.546200Z 0 [Note] InnoDB: Starting shutdown... 2020-01-19T02:53:12.646432Z 0 [Note] InnoDB: Dumping buffer pool(s) to /data/db/mysql/3306/ib_buffer_pool 2020-01-19T02:53:12.646755Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200119 10:53:12 2020-01-19T02:54:13.681401Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T02:55:13.816254Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T02:56:13.950719Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T02:57:14.089714Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T02:58:14.224542Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T02:59:14.359689Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T03:00:14.495265Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T03:01:14.700377Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T03:02:14.948073Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T03:03:15.183713Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-01-19T03:04:15.319860Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool |
会发现大量的[Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool等待。
出现这种情况,很大一部分原因是因为MySQL的时间与服务器时间不匹配造成的。
当发生这种情况时,快速关闭MySQL的服务其实很简单。
1:新打开一个会话,查看日志,从日志能看到当前MySQL的时间2020-01-19T03:04:15.319860Z
2:我们查看操作系统的当前时间:
[root@msp ~]# date
Mon Jan 19 8:39:11 CST 2020
3:我们只需调整一下服务器时间即可,调整到MySQL时间之后的时间点
[root@msp ~]# date -s 2020-01-20
Mon Jan 20 00:00:00 CST 2020
[root@msp ~]#
4:此时,再切换到关闭MySQL服务的页面,你会发现,服务已经关闭了。