[drupal-devel] MySQL 3, MySQL 4 and MySQL 5

[Gerhard Killesreiter]

On Sun, 1 May 2005, Daniel Convissor wrote:

> On Sun, May 01, 2005 at 07:25:34PM +0200, Dries Buytaert wrote:
> >
> > From my investigation, making MySQL 4 a requirement would allow us to
> > use row-level locking and transactions,
>
> Don't forget that for such things to work the tables need to use the
> InnoDB engine.

How would the myISAM  engine respond to such a sql query? would it lock
the whole table instead of a row?

Do you have experience with using InnoDB? Does it have other
(dis)advantages? Should we consider to use InnoDB for some tables?

Cheers,
	Gerhard