Lock innoDB table temporarily

Posted by Industrial on Stack Overflow See other posts from Stack Overflow or by Industrial
Published on 2010-05-07T18:27:40Z Indexed on 2010/05/07 18:38 UTC
Read the original article Hit count: 171

Filed under:
|
|
|

Hi everyone,

I make bigger inserts consisting of a couple of thousand rows in my current web app and I would like to make sure that no one can do anything but read the table, until the inserts have been done.

What is the best way to do this while keeping the read availability open for normal, non-admin users?

Thanks!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about innodb