Comment 1 for bug 1149755

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

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.