At 03:16 AM 23/04/2003 +1000, Chris Nolan wrote:
Not at all!
http://www.mysql.com/doc/en/mysqldump.html
My understanding of the way READ_COMMITTED works is that a the dump process
will only see the results of a transaction after it is committed.
I assume the dump process works by processing each table in some order
(this may be incorrect).
If the above is correct, then:
Dumper Process: Start TX READ_COMMITTED
Dumper Process: Dump MESSAGES
Other Process: Start TX
Dumper Process: Start Dumping MESSAGEBLKS
Other Process: Insert MESSAGES
Other Process: Insert MESSAGEBLKS
Other Process: Commit
Dumper Process: Will now see new MESSAGEBLKS, but has already dumped
MESSAGES so will not get the headers.
This would seem to lead to inconsistency, but it is based on a naieve view
of the way mySQL dumps work.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
