Not the answer you need?
Register and ask your own question!

Rules for running pt-online-schema-change on XtraDB Cluster

emerge30emerge30 EntrantInactive User Role Beginner
I have a 3 node XtraDB cluster running version 5.6.24-72.2-56. Last week I took the cluster down to one node, imported a single database by importing the schema, exporting the innobackup with the export option, dropping the table space, and importing the tablespace. I then bootstrapped the cluster from the single node. The database replicated as expected and is available on all nodes, however the larger tables were in obvious need of optimization, queries against the database were taking an extraordinarily long time to complete.

I attempted an optimize by running pt-online-schema-change --alter "Engine=InnoDB" against the larger tables, which failed with error "Copying rows caused a MySQL error 1180", The message was: Got error 5 during COMMIT.

The table itself is not yet in use, so I'm not worried about locking, but for whatever reason when running Optimize against this table directly causes the entire server to lock up, not just the table.

Any assistance would be appreciated.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.