Consistent partial table dumps with mysqldump

[Ryan Brothers]

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-transaction, and have it use that session rather than create a new snapshot?

Thanks for your help.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3509