Good to see the issue has been solved. What I noticed in the mysqltuner output, is that
you may want to enlarge your table_cache and open files limit before you run into
problems there.
----- Original Message -----
> From: "Johnny Withers" <johnny@stripped>
>
> I haven't used MYISAM in a long time, so i'm not sure about this
> but.. is the INSERT locked due to the SELECT queries that have been running
> for so long? And are the rest of the selects (with <8s running time) locked
> by the INSERT?
Yes, because MyISAM doesn't have a mechanism for keeping multiple concurrent consistent
views on a table, SELECT also locks the table for writes. There is one important and
occasionally useful exception, though: if there are no holes in the table (ie, if you
haven't done any deletes) the engine will allow inserts to append to the table while
selects are happening.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
