Not the answer you need?
Register and ask your own question!

InnoDB: Waiting for page_cleaner to finish flushing of buffer pool keep cleaning

newtomysqlnewtomysql ContributorCurrent User Role Beginner
I have a very small percona 5.7 test server. I wanted to add the slow query log. After change the .cnf I tried to restart my percona but in the logs I keep seeing this.


2017-09-27T10:21:12.196823Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-09-27T10:21:12.197154Z 0 [Note] InnoDB: Starting shutdown...
2017-09-27T10:21:12.297422Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-09-27T10:21:12.309798Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170927 12:21:12
2017-09-27T10:21:12.497668Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:22:12.692242Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:23:12.883339Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:24:13.076417Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:25:13.296141Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:26:13.476340Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:27:13.665939Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:28:13.862782Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:29:14.063633Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:30:14.255680Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:31:14.446311Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:32:14.638242Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:33:14.832268Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:34:15.020485Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:35:15.215550Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:36:15.408604Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:37:15.597909Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:38:15.792235Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:39:15.991048Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:40:16.184162Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:41:16.379047Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:42:16.570736Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:43:16.763312Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:44:16.952856Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:45:17.138069Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:46:17.330885Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:47:17.517536Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:48:17.707317Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:49:17.901309Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:50:18.092379Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-27T10:51:18.286690Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

How to recover it the fastest way ?

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.