3 Added backup tag since mysqldump performs backups
| link
2 edited tags; edited title
| link

Is it safe to run parallel innodb single-transaction dumps of individual tables?

1
source | link

Is it safe to run parallel innodb single-transaction of individual tables

I can't seem to find the internals for --single-transaction mysqldump option for InnoDB tables, but is it possible to use --single-transaction for single tables in a parallel dump so that the --single-transaction only affects the current table I'm dumping and it is safe to run in parallel for quicker dumps? I tested this on a development server and works well but without knowing the internal locking methods I am worried to use it in production