Hi,
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.)
select
'innodb',
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'
from (
select sum(index_length) + sum(data_length) as raw
from information_schema.tables
where engine ='innodb'
) sum
innodb
totalLen
innodb_buffer_pool_size
Suggested change
innodb
167.8MB
134217728
28259123
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?