Re: [drupal-devel] LOCK vs. SELECT FOR UPDATE

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.