MySQL Forums
Forum List  »  InnoDB

2017-09-12T19:04:53.549339Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23911ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
Posted by: Jac Abraham
Date: October 09, 2017 11:30AM

I have MySQL Community Edition v5.7.18 running on 2 boxes with exactly the same configuration (64GB RAM, C7000+SAN+VirtualConnect, 64GB RAM, write intensive).

I am encountering this page_cleaner issue on Box1 and not on Box2.

I have tried to make several changes to the configuration parameters in my.cnf. However nothing seems to help with this issue on Box1.


Some of the changes made are as below:
innodb_buffer_pool_size | 53687091200
innodb_flush_log_at_trx_commit | 0
innodb_flush_method | O_DIRECT
innodb_flush_neighbors | 0
innodb_io_capacity | 200
innodb_io_capacity_max | 2000
innodb_log_buffer_size | 8388608
innodb_log_buffer_size | 8388608
innodb_log_file_size | 4294967296
innodb_log_files_in_group | 2
innodb_lru_scan_depth | 512
innodb_write_io_threads | 16

Any inputs on how to go about fixing this issue on System1?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
2017-09-12T19:04:53.549339Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23911ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
55
October 09, 2017 11:30AM


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.