2014-05-27 17:20:52 |
Seppo Jaakola |
bug |
|
|
added bug |
2014-05-27 17:21:38 |
Seppo Jaakola |
description |
Foreign key processing is suspected to cause performance bottleneck.
One test manifesting this is to load employee database from: https://launchpad.net/test-db/, and measure load times when FKs are enabled / disabled.
Here are test results with MySQL 5.6.17 development head version, compared to native MySQL 5.6.17:
mysql -uroot < employees.sql
2 node GC cluster 5.6.17 dev mysql 5.6.17
FK ON: 1m32.696s 0m36.379s
FK OFF: 1m1.442s 0m35.025s
=> FK overhead in cluster is roughly 50% |
Foreign key processing is suspected to cause performance bottleneck.
One test manifesting this is to load employee database from: https://launchpad.net/test-db/, and measure load times when FKs are enabled / disabled.
Here are test results with Galera Cluster 5.6.17 development head version, compared to native MySQL 5.6.17:
mysql -uroot < employees.sql
2 node GC cluster 5.6.17 dev mysql 5.6.17
FK ON: 1m32.696s 0m36.379s
FK OFF: 1m1.442s 0m35.025s
=> FK overhead in cluster is roughly 50% |
|
2014-05-27 17:23:14 |
Seppo Jaakola |
description |
Foreign key processing is suspected to cause performance bottleneck.
One test manifesting this is to load employee database from: https://launchpad.net/test-db/, and measure load times when FKs are enabled / disabled.
Here are test results with Galera Cluster 5.6.17 development head version, compared to native MySQL 5.6.17:
mysql -uroot < employees.sql
2 node GC cluster 5.6.17 dev mysql 5.6.17
FK ON: 1m32.696s 0m36.379s
FK OFF: 1m1.442s 0m35.025s
=> FK overhead in cluster is roughly 50% |
Foreign key processing is suspected to cause performance bottleneck.
One test manifesting this is to load employee database from: https://launchpad.net/test-db/, and measure load times when FKs are enabled / disabled.
Here are test results with Galera Cluster 5.6.17 development head version, compared to native MySQL 5.6.17:
mysql -uroot < employees.sql
2 node Cluster 5.6.17 mysql 5.6.17
FK ON: 1m32.696s 0m36.379s
FK OFF: 1m1.442s 0m35.025s
=> FK overhead in cluster is roughly 50% |
|
2014-05-27 17:24:21 |
Seppo Jaakola |
description |
Foreign key processing is suspected to cause performance bottleneck.
One test manifesting this is to load employee database from: https://launchpad.net/test-db/, and measure load times when FKs are enabled / disabled.
Here are test results with Galera Cluster 5.6.17 development head version, compared to native MySQL 5.6.17:
mysql -uroot < employees.sql
2 node Cluster 5.6.17 mysql 5.6.17
FK ON: 1m32.696s 0m36.379s
FK OFF: 1m1.442s 0m35.025s
=> FK overhead in cluster is roughly 50% |
Foreign key processing is suspected to cause performance bottleneck.
One test manifesting this is to load employee database from: https://launchpad.net/test-db/, and measure load times when FKs are enabled / disabled.
Here are test results with Galera Cluster 5.6.17 development head version, compared to native MySQL 5.6.17:
mysql -uroot < employees.sql
2 node Cluster mysql 5.6.17
FK ON: 1m32.696s 0m36.379s
FK OFF: 1m1.442s 0m35.025s
=> FK overhead in cluster is roughly 50% |
|
2014-05-27 22:28:17 |
Marco Tusa |
bug |
|
|
added subscriber Marco Tusa |
2014-06-16 19:25:07 |
Raghavendra D Prabhu |
bug task added |
|
percona-xtradb-cluster |
|
2014-06-16 19:25:28 |
Raghavendra D Prabhu |
nominated for series |
|
percona-xtradb-cluster/5.6 |
|
2014-06-16 19:25:28 |
Raghavendra D Prabhu |
bug task added |
|
percona-xtradb-cluster/5.6 |
|
2014-06-16 19:25:28 |
Raghavendra D Prabhu |
nominated for series |
|
percona-xtradb-cluster/trunk |
|
2014-06-16 19:25:28 |
Raghavendra D Prabhu |
bug task added |
|
percona-xtradb-cluster/trunk |
|
2014-09-17 10:55:55 |
Miguel Angel Nieto |
codership-mysql: status |
New |
Confirmed |
|
2014-09-17 10:55:58 |
Miguel Angel Nieto |
percona-xtradb-cluster/5.5: status |
New |
Confirmed |
|
2014-09-17 10:56:01 |
Miguel Angel Nieto |
percona-xtradb-cluster/5.6: status |
New |
Confirmed |
|
2014-09-24 07:47:02 |
Miguel Angel Nieto |
bug |
|
|
added subscriber Miguel Angel Nieto |
2015-11-17 11:39:40 |
Krunal Bauskar |
percona-xtradb-cluster/5.5: importance |
Undecided |
Medium |
|
2015-11-17 11:39:41 |
Krunal Bauskar |
percona-xtradb-cluster/5.6: importance |
Undecided |
Medium |
|