regression test for lp:1100496 runs too slowly

Bug #1262887 reported by Seppo Jaakola on 2013-12-19
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Medium
Seppo Jaakola
5.6
Undecided
Seppo Jaakola
Percona XtraDB Cluster
Status tracked in 5.6
5.5
Undecided
Unassigned
5.6
Undecided
Unassigned

Bug Description

Running the regression test for lp:1100496 shows that the slave node freezes for long periods. The test will eventually pass, but just takes too long to complete.

Running same test against a native MySQL replication pair does not show similar slowness.

Changed in codership-mysql:
assignee: nobody → Seppo Jaakola (seppo-jaakola)
status: New → In Progress
Changed in codership-mysql:
status: In Progress → Fix Committed
Seppo Jaakola (seppo-jaakola) wrote :

Fix was pushed into wsrep-5.5, in revision: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3934

The problem was due to InnoDB purge thread which would not treat lock types on WSREP_BF correctly when inheriting locks.

In the fix, InnoDB lock manager was refactored to not use WSREP_BF lock mode anymore. Locking priority is implemented by checking running transactions BF state at the time of each lock conflict. We will need another round of refactoring, to not access mysql THD structure for each lock conflict, transaction state can be held in InnoDB trx.

Seppo Jaakola (seppo-jaakola) wrote :

The problem does not show up in MySQL 5.6 version. This is because of kernel_mutex has been dropped in 5.6. In 5.5 version, InnoDB purge thread holds kernel_mutex, which finally accumulated the issue.

But, nevertheless, refactoring of WSREP_BF lock mode out, looks like good to merge to 5.6 branch as well. I will start work on this task.

Seppo Jaakola (seppo-jaakola) wrote :

Pushed a cleanup fix for wsrep-5.5: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3939

There was a problem, which made native build (without WITH_WSREP option) to fail

Merged the fix into wsrep-5.6, in revision:
http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4032

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers