Page cleaner took x ms to flush x pages

1

My log is filled with Page cleaner took 4471ms to flush 200 pages and I think this is causing stability issues with the node. Is there any setting I should change.

Here is my my.cnf file.

log-error=/var/log/mysql/error.log
default_storage_engine=InnoDB
sql_mode =     STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

innodb_buffer_pool_size = 20G
innodb_buffer_pool_instances = 8
innodb_lock_wait_timeout = 100 #default is 50 seconds
wait_timeout = 86400 #was 86400 defaut is 28800 seconds
interactive_timeout = 86400 #was 86400 default is 28800 seconds

max_heap_table_size = 96M
sort_buffer_size = 16M
join_buffer_size = 16M
tmp_table_size = 96M
max_sort_length = 8K

max_allowed_packet = 16M
group_concat_max_len = 16M
max_connections = 200
max_connect_errors = 10
max_binlog_size = 128M

log-bin=binlog
log_replica_updates

#Binary log expiration period is 604800 seconds, which equals 7 days
binlog_expire_logs_seconds=604800

wsrep_provider=/usr/lib/galera4/libgalera_smm.so
wsrep_provider_options="gcache.size = 5G; gcache.dir = /db2/cache"
wsrep_cluster_address=gcomm://192.168.2.59,192.168.2.60,192.168.2.62
binlog_format=ROW
wsrep_applier_threads=8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.2.64
wsrep_cluster_name=Web-Cluster
pxc_strict_mode=PERMISSIVE

Any help would be appreciated.

1 Like
2

Hello, those kind of messages are usually related to slow IO subsystem. I suggest you check your storage performance with PMM and/or pt-diskstats.

1 Like
3

Ok thank you for the suggestion.

1 Like
4

You can increase innodb_io_capacity to 400 and see if that helps.

1 Like