Consistent partial table dumps with mysqldump
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
I am running Percona Server 5.6 and using mysqldump to do partial table dumps for a large number of tables. I'm doing this by calling mysqldump once for each table, passing in a different --where clause for each table.
This method works great except that the dump as a whole isn't consistent because mysqldump created a separate transaction each time it was called.
I see that Percona Server supports the following statement where it pulls the snapshot details from another session:
START TRANSACTION WITH CONSISTENT SNAPSHOT FROM SESSION <session_id>;
Would it be possible to allow the session_id to be passed to mysqldump, perhaps as an argument to --single-
Thanks for your help.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3509