【MySQL】[Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

xixuefeng MySQL 2020-01-20 8:52:05  2,810 次浏览  已关闭评论

好多人应该都遇到过类似如下问题

[root@msp ~]# service mysql stop
Shutting down MySQL.......................................................................
..........................................................................................
..........................................................................................
..........................................................................................
..........................................................................................
..........................................................................................
..........................................................................................
..........................................................................................
..........................................................................................
...................

[root@msp ~]# service mysql stop

Shutting down MySQL.......................................................................

..........................................................................................

...................

关闭MySQL服务时，长时间等待也关闭不了。此时查看日志，如下：

[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

[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服务的页面，你会发现，服务已经关闭了。

上一篇：【Shell】exit 0 1

下一篇：【Docker】修改镜像源

【MySQL】[Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

分类目录

文章归档

功能

2024年4月
一	二	三	四	五	六	日
« 11月
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

【MySQL】[Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

和本文关系暧昧的

分类目录

文章归档

功能