Even though we see buf_LRU_file_dump at the top here, it is not
conclusive because of lp:1152571 - in short, the galera libs are
not included in that. We also see gcs_recv and other galera
functions in that.
However, the issue here is "innodb_buffer_pool_restore_at_startup 1"
That is a very small interval and is certain to cause issues for
the following reasons:
You are asking the LRU_dump thread to scan the entire 90G buffer
pool's LRU every second (while holding the LRU list mutex).
Even though we see buf_LRU_file_dump at the top here, it is not
conclusive because of lp:1152571 - in short, the galera libs are
not included in that. We also see gcs_recv and other galera
functions in that.
However, the issue here is "innodb_ buffer_ pool_restore_ at_startup 1"
That is a very small interval and is certain to cause issues for
the following reasons:
You are asking the LRU_dump thread to scan the entire 90G buffer
pool's LRU every second (while holding the LRU list mutex).
I would go with a duration like 60s or so.