Re: [sr-dev] db_mysql with Transaction support

Hello,

So, should I start modifying the install scripts so that we use InnoDB engine, or is a table-lock sufficient when myisam is used? Mysql will not give an error if the engine does not support locking on individual rows. So the experience will be transparent for the end user, except for the locking of the whole table.

A table lock might be OK, but probably far less efficient than row locks. There is also the possibility of there being some deadlocks in the presence code if entire table locks are used - I can't say whether this is likely or not as I haven't taken a critical look at the code with that in mind.

Regards,

Peter