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

Non-blocking operation to back up MyISAM tables using Percona XtraBackup?

marc5435678marc5435678 EntrantInactive User Role Beginner
On the page https://www.percona.com/software/mysql-database/percona-xtrabackup/supported-technologies it mentions the following:
Percona XtraBackup can back up the following storage engines by briefly pausing writes at the end of the backup: MyISAM, Merge, Archive ...

I am using MySQL 5.6.30 and Percona XtraBackup 2.3.4 to backup a MyISAM table of approximately 32 million records but I am only experiencing a full table lock while the backup operation is happening. So it's less of a brief pause at the end of the backup and more of a long pause throughout the entire process.

Is there a flag I need to pass into XtraBackup to achieve this functionality? The command I've been using so far is as follows:



Thank you in advance for your help!

Marc
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.