Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1104

LP #1323765: Degraded performance due to FKs

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Seppo Jaakola last update 17-11-2015 11:39:41

      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%

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: