30 Oct
2018
30 Oct
'18
7:25 a.m.
Hi all,
I am seeing a lot of warnings with mariadb's server from yesterday:
InnoDB: page_cleaner: 1000ms intended loop took 10945ms. The settings might not be optimal.
According to mysql and mariadb docs, this problem is related to number of page cleaner threads. And it can only set innodb_page_cleaners as high as innodb_buffer_pool_instances. But on the basis of which options should I adjust these two parameters?
Regards, C. L. Martinez