[drupal-devel] LOCK vs. SELECT FOR UPDATE

Nicolas Tostin nicolast at logis.com.mx
Tue Sep 27 15:40:29 UTC 2005

> until now we've largely ignored people who aren't allowed to lock their
> tables and thus cannot use Drupal. Somebody suggested
> (http://drupal.org/node/1190#comment-55984) to use SELECT FOR
> UPDATE in database.mysql.inc instead. Is there any database expert who can
> comment on the pros and cons of the approach?

I remember we discuss this a few monthes ago see
The problem is that you need MySQL 4 and InnoDb tables to use this.

More information about the drupal-devel mailing list