2014-02-07 21:18:33 |
Jay Janssen |
bug |
|
|
added bug |
2014-02-07 22:05:27 |
Jay Janssen |
summary |
5.6 cluster node that is a slave with parallel worker threads seems to generate writesets that are not parallelizable |
5.6 cluster reports wsrep_cert_deps_distance=1.0 in all cases |
|
2014-02-07 22:07:53 |
Jay Janssen |
description |
I don't have this fully locked down, but I suspect there may be something here:
Scenario: 2 node cluster, first node has 10 --slave-parallel-threads in inbound async replication. No other writes, wsrep_preordered=OFF.
2nd node starts and gets stuck in JOINED catching up very slowly, 80-100 tps.
2nd node has a persistent wsrep_cert_deps_distance=1.0000
1st node is very fast by itself: 1k+ tps, but 2nd node JOINED sends a lot of FC.
My diagnosis is that the send node can't keep up because the writesets are not allowing parallelism for some reason. My hunch is that this may be related to slave-parallel-workers. |
PXC 5.6.16, Galera 3.3, latest GA release.
Standard Linux 3 node running sysbench 8 threads on one node. Other nodes permanently report wsrep_cert_deps_distance=1.
| wsrep_cert_deps_distance | 1.000000 |
| wsrep_apply_oooe | 0.000000 |
| wsrep_apply_oool | 0.000000 |
| wsrep_apply_window | 1.101769 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 1.000000 |
Does this mean parallel apply is not working or wsrep_cert_deps_distance is simply broken? |
|
2014-02-10 14:48:35 |
Teemu Ollakka |
bug task added |
|
codership-mysql |
|
2014-02-10 14:48:48 |
Teemu Ollakka |
nominated for series |
|
codership-mysql/5.6 |
|
2014-02-10 14:48:48 |
Teemu Ollakka |
bug task added |
|
codership-mysql/5.6 |
|
2014-02-10 16:45:06 |
Ovais Tariq |
bug |
|
|
added subscriber Ovais Tariq |
2014-02-10 18:42:13 |
Teemu Ollakka |
nominated for series |
|
codership-mysql/5.5 |
|
2014-02-10 18:42:13 |
Teemu Ollakka |
bug task added |
|
codership-mysql/5.5 |
|
2014-02-10 20:59:28 |
Launchpad Janitor |
branch linked |
|
lp:codership-mysql/5.5 |
|
2014-02-10 20:59:25 |
Launchpad Janitor |
branch linked |
|
lp:codership-mysql |
|
2014-02-10 21:01:53 |
Teemu Ollakka |
codership-mysql/5.5: status |
New |
In Progress |
|
2014-02-10 21:01:55 |
Teemu Ollakka |
codership-mysql/5.6: status |
New |
In Progress |
|
2014-02-10 21:01:57 |
Teemu Ollakka |
codership-mysql/5.5: importance |
Undecided |
High |
|
2014-02-10 21:01:59 |
Teemu Ollakka |
codership-mysql/5.6: importance |
Undecided |
High |
|
2014-02-10 21:02:01 |
Teemu Ollakka |
codership-mysql/5.5: assignee |
|
Teemu Ollakka (teemu-ollakka) |
|
2014-02-10 21:02:03 |
Teemu Ollakka |
codership-mysql/5.6: assignee |
|
Teemu Ollakka (teemu-ollakka) |
|
2014-02-10 21:02:07 |
Teemu Ollakka |
codership-mysql/5.5: milestone |
|
5.5.36-25.10 |
|
2014-02-10 21:02:11 |
Teemu Ollakka |
codership-mysql/5.6: milestone |
|
5.6.16-25.3 |
|
2014-02-10 21:08:22 |
Teemu Ollakka |
codership-mysql/5.5: status |
In Progress |
Fix Committed |
|
2014-02-10 21:08:25 |
Teemu Ollakka |
codership-mysql/5.6: status |
In Progress |
Fix Committed |
|
2014-02-11 05:59:17 |
Raghavendra D Prabhu |
nominated for series |
|
percona-xtradb-cluster/5.6 |
|
2014-02-11 05:59:17 |
Raghavendra D Prabhu |
bug task added |
|
percona-xtradb-cluster/5.6 |
|
2014-02-11 05:59:17 |
Raghavendra D Prabhu |
nominated for series |
|
percona-xtradb-cluster/trunk |
|
2014-02-11 05:59:17 |
Raghavendra D Prabhu |
bug task added |
|
percona-xtradb-cluster/trunk |
|
2014-02-11 05:59:38 |
Raghavendra D Prabhu |
percona-xtradb-cluster/trunk: milestone |
|
5.5.36-25.10 |
|
2014-02-11 05:59:41 |
Raghavendra D Prabhu |
percona-xtradb-cluster/5.6: milestone |
|
5.6-future |
|
2014-02-11 05:59:55 |
Raghavendra D Prabhu |
percona-xtradb-cluster/5.6: status |
New |
Fix Committed |
|
2014-02-11 06:00:48 |
Raghavendra D Prabhu |
percona-xtradb-cluster/trunk: status |
New |
Fix Committed |
|
2014-02-13 15:41:09 |
Raghavendra D Prabhu |
percona-xtradb-cluster/5.6: milestone |
5.6-future |
5.6.15-25.4 |
|
2014-02-14 11:11:16 |
Raghavendra D Prabhu |
summary |
5.6 cluster reports wsrep_cert_deps_distance=1.0 in all cases |
5.6 cluster reports wsrep_cert_deps_distance=1.0 in all cases | Parallel Apply not working |
|
2014-02-14 11:11:31 |
Raghavendra D Prabhu |
percona-xtradb-cluster/trunk: importance |
Undecided |
High |
|
2014-02-14 11:24:20 |
Raghavendra D Prabhu |
percona-xtradb-cluster/5.6: importance |
Undecided |
High |
|
2014-02-20 11:13:24 |
Hrvoje Matijakovic |
percona-xtradb-cluster/5.6: status |
Fix Committed |
Fix Released |
|
2014-03-13 12:04:34 |
Alex Yurchenko |
codership-mysql/5.6: status |
Fix Committed |
Fix Released |
|
2014-05-09 05:43:35 |
Hrvoje Matijakovic |
percona-xtradb-cluster/trunk: status |
Fix Committed |
Fix Released |
|
2014-05-14 09:53:15 |
Alex Yurchenko |
codership-mysql/5.5: status |
Fix Committed |
Fix Released |
|