On Mon, Aug 18, 2003 at 04:14:21PM +1000, Chris Nolan wrote: > Hi all! > > Currently, one of my clients has a MySQL+InnoDB database that they use for > storing "stuff". My question is, even though I know it will take more time > and will slow down operations for everyone, will mysqldump with the single > transaction option give a consistant snapshot of InnoDB tables if I have > the isolation level set to READ_COMMITED ?
Yes. mysqldump respects the isolation level. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 17 days, processed 881,341,053 queries (585/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]