> I'm trying out a DNM devstack patch [2] to set innodb_lru_scan_depth=256 and keep rechecking the DNM nova change [3] to see if it has any effect on the failures.
Well, this seems to have the opposite of the desired effect [4]:
2020-03-12T22:59:10.304511Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7728ms. The settings might not be optimal. (flushed=30 and evicted=0, during the time.)
2020-03-12T22:59:33.848105Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11540ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2020-03-12T23:00:23.206041Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11356ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2020-03-12T23:00:44.698049Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8507ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2020-03-12T23:01:21.877705Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6176ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
but at least I can see the setting change did something.
It also happened to not fail the job run either. I'm going to try out some other settings related to the buffer pool next.
> I'm trying out a DNM devstack patch [2] to set innodb_ lru_scan_ depth=256 and keep rechecking the DNM nova change [3] to see if it has any effect on the failures.
Well, this seems to have the opposite of the desired effect [4]:
2020-03- 12T22:59: 10.304511Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7728ms. The settings might not be optimal. (flushed=30 and evicted=0, during the time.) 12T22:59: 33.848105Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11540ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.) 12T23:00: 23.206041Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11356ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.) 12T23:00: 44.698049Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8507ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.) 12T23:01: 21.877705Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6176ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2020-03-
2020-03-
2020-03-
2020-03-
but at least I can see the setting change did something.
It also happened to not fail the job run either. I'm going to try out some other settings related to the buffer pool next.
[1] https:/ /stackoverflow. com/questions/ 41134785/ how-to- solve-mysql- warning- innodb- page-cleaner- 1000ms- intended- loop-took- xxx /review. opendev. org/712805 /review. opendev. org/701478 /storage. gra.cloud. ovh.net/ v1/AUTH_ dcaab5e32b234d5 6b626f72581e364 4c/zuul_ opendev_ logs_18a/ 701478/ 5/check/ grenade- py3/18a9555/ controller/ logs/mysql/ error_log. txt
[2] https:/
[3] https:/
[4] https:/