MYSQL:[Note] InnoDB: page_cleaner: 1000ms intended loop took 4303ms. The settings might not be optimal. (flushed=396 and evicted=0, during the time.)

Ask Question

Asked 7 years, 6 months ago

Modified 7 years, 6 months ago

Viewed 6k times

In MySQL5.7.11,the error log display the

"[Note] InnoDB: page_cleaner: 1000ms intended loop took 4303ms. The settings might not be optimal. (flushed=396 and evicted=0, during the time.)"

frequently,and I set the parameter innodb_page_cleaners=8 and innodb_buffer_pool_instances=8 and reboot the MYSQL service,but the error also show frequently,what should I do ? Please help me!Thanks a lot!

edited May 17, 2016 at 5:15

Dinidu Hewage

1378 bronze badges

asked May 17, 2016 at 3:51

lishengheng

311 silver badge2 bronze badges

When this happens (so the 4s before the message appears), is there some CPU or IO spike maybe? Is your server doing a lot of work? Do you use HDD or SSD storage?
– jkavalik
May 17, 2016 at 5:18
yes,the CPU and IO is high,the mysql5.7.11 is the slave of mysql5.6.21,the slave is doing replications,I use the general HDD.
– lishengheng
May 17, 2016 at 6:12
You might want to have a look at the following Q&A over on Stackoverflow: How to solve mysql warning: “InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal”?.
– John K. N.
Jan 4, 2018 at 6:41

Add a comment |

0 Your Answer

Sign up or log in

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Stack Exchange Network

MYSQL:[Note] InnoDB: page_cleaner: 1000ms intended loop took 4303ms. The settings might not be optimal. (flushed=396 and evicted=0, during the time.)

0

Your Answer

Browse other questions tagged
mysql
or ask your own question.

Linked

Hot Network Questions

MYSQL:[Note] InnoDB: page_cleaner: 1000ms intended loop took 4303ms. The settings might not be optimal. (flushed=396 and evicted=0, during the time.)

0

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Post as a guest

Browse other questions tagged mysql or ask your own question.

Linked

Related

Hot Network Questions

Browse other questions tagged
mysql
or ask your own question.