Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1102

LP #1173311: pt-online-schema-change results in many more deadlocks under MySQL 5.6

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Brian Durand last update 03-05-2013 15:55:22

      I recently tried running pt-online-schema-change on a large (56M+ row) active table (many reads and writes to it per second) under MySQL 5.6 (Oracle community edition). It resulted in many deadlocks and I had to shutdown the process. Playing with chunk size and max-load threads only had any effect if I reduced them to values so low that the schema change was going to take 2 days to finish.

      I had recently run a pt-online-schema-change on this same table with no such deadlocks when we were still on Percona Server 5.5.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist