Bug #62845 Option to set tx_isolation in mysqldump
Submitted: 20 Oct 2011 13:47 Modified: 20 Oct 2011 14:04
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:any OS:Any
Assigned to: CPU Architecture:Any

[20 Oct 2011 13:47] Peter Laursen 
Description:
If server is running READ COMMITTED tx_isolation level globally the mysqldump --single_transaction option is not much use and does not ensure a consistent snapshot as far as I can understand.

(apart from that I reported another issue with --single-transaction here http://bugs.mysql.com/bug.php?id=62844)

How to repeat:
See above.

Suggested fix:
tx_isolation can be SET as a SESSION variable to REPEATABLE-READ. This should either be implicit with --single-transaction or a seperate option should be added to handle this.

Docs does not tell that mysqldump does this implicitly so I assume that it does not (and I am too lazy to check general log! :-) )
[20 Oct 2011 14:04] Peter Laursen 
sorry this is a duplciate.  I already reported this in http://bugs.mysql.com/bug.php?id=62104