[lug] MySQL work queue problem

Zan Lynx zlynx at acm.org
Fri Oct 6 17:36:53 MDT 2006


On Fri, 2006-10-06 at 15:02 -0600, Evelyn Mitchell wrote:
> * On 2006-10-06 14:32 George Sexton <gsexton at mhsoftware.com> wrote:
> > 
> > If a second thread tries the update statement, the row count will be 0 
> > because the status field has already been changed. That's assuming that 
> > MySQL can actually atomically update records...
> 
> I though that MySQL achieved some of their performance at the risk of data
> integrity. Namely, that they don't support Atomic changes with rollback,
> or anything close to full database ACID. Postgres, does support full ACID,
> by the way. 
> 
> Do you want fast or correct, or just how important is this data to your
> users?

That's old information now.  MySQL's current versions support a variety
of table backends, some of which implement full ACID compliance.  You
can still choose fast and loose if you want it though.

http://dev.mysql.com/doc/refman/5.1/en/storage-engine-choosing.html
-- 
Zan Lynx <zlynx at acm.org>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20061006/d955e868/attachment.pgp>


More information about the LUG mailing list