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
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