Myisam Locking

andrea.m86 · Post by **andrea.m86** » Tue 07 Jun 2011 08:58

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!

andrea.m86 · Post by **andrea.m86** » Tue 07 Jun 2011 10:03

I need to lock only records, not the whole tables...

AndreyZ · Post by **AndreyZ** » Tue 07 Jun 2011 11:05

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

andrea.m86 · Post by **andrea.m86** » Tue 07 Jun 2011 14:12

Ok! Thanks!