Are entries in the update log recorded in the *exact* 
order that the SQL 'hits the database'?

I am using mysql version 3.22.22.

I would normally assume the log was accurate but someone just 
told me that with mySQL log entries can be out of order by a few seconds 
because different mySQL processes write to the one log file.
Thus they have to wait for the other to complete.
Is this true? 

Also, are log entries written in the order that the SQL requests
come in, or in the order that the requests are completed?

Regards,
Sonam









-- 
Electronic Commerce
Corporate Express Australia Ltd.
Phone: +61-2-9335-0725 Fax: +61-2-9335-0753

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to