title: How do I determine maximum transaction size in MySQL?
body: <p>Saw the same question posited for PostgreSQL <a href="https://stackoverflow.com/questions/709708/maximum-transaction-size-in-postgresql">here</a>; wondering if anyone knows (a) the MySQL flavour of the response and (b) which MySQL options I would examine to determine/influence the answer.</p>
  
  <p>I don't need an absolute answer btw, but if I were to propose inserting, say, 200,000 rows of ~2Kb each would you consider that very straightforward, or pushing the limit a bit?</p>
  
  <p>Assume MySQL is running on a well specced Linux box with 4Gb of RAM, shedloads of disk space, and an instance tuned by someone who generally knows what they're doing!</p>
  
  <p>Cheers</p>
  
  <p>Brian</p>