Hi Luke,
When mysql is doing a dump, do the updates that happen during the dump
get included in the dump.
I assume you mean 'mysqldump'.
I have a dump that starts at 11pm and goes for 2 hours. If someone
updates data at say 11:45pm, does that update get included in the dump?
When does the window, on what gets included in a dump, close?
By default, mysqldump doesn't do anything to ensure a consistent backup.
If you want one, you have to specify an option to get one, which will
depend on which storage engines you're using.
For InnoDB: Use the --single-transaction option. The window closes when
the dump starts. Users in other transactions/sessions will still be
able to write, but you won't see their writes in this transaction.
For MyISAM: Use the --lock-tables option. The window closes when the
dump starts. Users won't be able to write at all, to any tables being
dumped, while the dump is running.
In general, you want a consistent snapshot of all tables from the same
point in time, and you will want to use one of the above options to get it.
Regards,
Jeremy
--
Jeremy Cole
MySQL Geek, Yahoo! Inc.
Desk: 408 349 5104
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
