We have a few sql statements that take up to 10 minutes to run.
they are run like
INSERT INTO blah (SELECT...
and that Select probably has a join or two...
Tables are MyISAM.
when this is running my whole website goes down as the login page has a
select that has to wait for that big query to finish.
What I would like to do, is the following
1. put a WRITE lock on the table so other selects will work
2. run the statement without SELECT locking
3. remove the write lock
so my 2 questions are: