I have a small mysql 5.7 server for testing. I left everything in default state and I wanted to add a slow query log. Thus I needed to restart my machine it took a long time nearly 1 hour and I saw a lot of this entries in the log.
InnoDB: Waiting for page_cleaner to finish flushing of buffer pool.
I ran this query.
Showing rows 0 - 0 (1 total, Query took 0.0471 seconds.)
concat(round(raw/1024/1024,1),'MB') as totalLen,
@@innodb_buffer_pool_size as innodb_buffer_pool_size,
round(raw-(1.1*@@innodb_buffer_pool_size),0) as 'Suggested change'
select sum(index_length) + sum(data_length) as raw
where engine ='innodb'
I got this as the results. I am confuse why is the suggestion less than the current pool size?
Should I increase the two ib_logfile log files size how much should I add? Their current size is just 50Mb.
Also I google here http://www.speedemy.com/how-to-speed-up-mysql-restart/
It suggest to add this innodb_max_dirty_pages_pct = 0; I am not too sure on this?
What else should I add to improvise this condition?