Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

  1. Bug #1108035
  2. Comment #12

Comment 12 for bug 1108035

Revision history for this message
Jay Janssen (jay-janssen) wrote : Re: [Bug 1108035] PXC innodb_buffer_pool_restore_at_startup and node joining cluster io resources race condition

On Feb 28, 2013, at 8:37 AM, Ilias Bertsimas <email address hidden> wrote:

> Yes it is flow control pause that stalls the cluster. That can be solved with innodb_blocking_buffer_pool_restore=ON

Ok, great. This bit is "not a bug" technically.

> But the side effect I mentioned is the restoration of the buffer pool pages twice.
>
> Once when wsrep tries to recover uuid:gtid in
> WSREP: Running position recovery with --log_error=/tmp/tmp.nci5tZ9xZF
> And the second time where it should recover the buffer pool pages if the node was not part of a galera cluster.

Yes, precisely. The wsrep_recover should not do an LRU reload. It's not technically a bug, but it's superfluous and obviously extra delay bringing up the node.

Jay Janssen, MySQL Consulting Lead, Percona
http://about.me/jay.janssen
Percona Live in Santa Clara, CA April 22nd-25th 2013
http://www.percona.com/live/mysql-conference-2013/