3 Apr
2013
3 Apr
'13
7:01 p.m.
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
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd