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

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?

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.