title: Mysqldump --single-transaction option
body: <p>Can somebody explain how <em>mysqldump</em> <code>--single-transaction</code> actually works for transactional tables, like InnoDB? I've read official <a href="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_single-transaction" rel="noreferrer">documentation</a> but still haven't glue. Does it perform per table lock instead of global lock as <code>--lock-tables</code> do? Also, mysqldump runs <code>--opt</code> as a default option, which includes <code>--lock-tables</code>, but they are mutually exclusive with <code>--single-transaction</code> as described in documentation link above. Should I use <code>--skip-opt</code> when using <code>--single-transaction</code> in single <em>mysqldump</em> command?  </p>
  
  <p>I need to dump InnoDB table with size of ~700 Gb and I'm looking the right command to achive this. Currently I use below one:</p>
  
  <pre><code> mysqldump -B my_db --quick --single-transaction --max_allowed_packet=512M --compress --order-by-primary
  </code></pre>
  
  <p>Thanks in advance.</p>