Page 1 of 1

Myisam Locking

Posted: Tue 07 Jun 2011 08:58
by andrea.m86
Hi
Is it possible to handle a locking system with a myisam DB? Any suggestion / example?
(The 'Lockmode' properties of the components refers only to innodb?)
Thanks!

Posted: Tue 07 Jun 2011 10:03
by andrea.m86
I need to lock only records, not the whole tables...

Posted: Tue 07 Jun 2011 11:05
by AndreyZ
Hello,

The point is that MyISAM doesn't support row-level locking, it supports only table-level locking. You can find more information about it here: http://dev.mysql.com/doc/refman/5.0/en/ ... cking.html

Posted: Tue 07 Jun 2011 14:12
by andrea.m86
Ok! Thanks!