Not the answer you need?
Register and ask your own question!

InnoDB: page_cleaner: 1000ms intended loop took 23911ms.

jacjac EntrantLegacy User Role Beginner
Seeing this message "InnoDB: page_cleaner: 1000ms intended loop took 23911ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)" in the MySQL logs several times (v5.7.18).
Using SSD.
RAM: 64GB

Tried changing the following configuration in my.cnf but did not resolve this issue:
innodb_buffer_pool_size=50GB
innodb_lru_scan_depth = 512
innodb_write_io_threads=16
innodb_flush_neighbor=0
innodb_log_file_size=100GB
innodb_log_files_in_group=2
innodb_change_buffer_max_size=50
innodb_log_buffer_size=4GB
innodb_max_dirty_pages_pct_lwm=30
innodb_thread_concurrency=0
innodb_write_io_threads=64
innodb_concurrency_tickets=500
innodb_thread_concurrency=16
innodb_io_capacity=1000
innodb_io_capacity_max=2000


Please provide some pointers on how to resolve this issue. Thanks in advance.

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.