Buy Percona ServicesBuy Now!

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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 ?

  • #2
    Hi newtomysql,

    do you use VirtualBox?
    can you install VirtualBox guest additions?

    Comment

    Working...
    X