Re: table locks in cursor. how it works?

[Yurii Korotia]

server starts to lag if we move one of tables to innodb (about 500k records). so we have mixed engines, myisam for old application part and innodb for new. we are planning to migrate, but historically it was built not very 'safely'.

also, as i understand, innodb only locks for write/update, but allows read.

I need to block any attempt to access data during my critical updates, so no ghost operations , etc.

Going to try locks on view with select for update with demo procedure




thanks



Edited 1 time(s). Last edit at 10/03/2012 03:48PM by Yurii Korotia.