MySQL Forums
Forum List  »  InnoDB

Innodb taking long time to restart on a small machine
Posted by: newbie Shai
Date: September 27, 2017 12:36PM

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'
from (
select sum(index_length) + sum(data_length) as raw
from information_schema.tables
where engine ='innodb'
) sum

Suggested change
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
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?

Options: ReplyQuote

Written By
Innodb taking long time to restart on a small machine
September 27, 2017 12:36PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.