[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Nicolas Tostin]

> 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
http://drupal.org/node/21439
The problem is that you need MySQL 4 and InnoDb tables to use this.