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.)
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.
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.)
3668
October 09, 2017 11:30AM
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.