mysql issue

[Jason Van Patten]

On 2/8/2012 11:50 AM, Merrill Oveson wrote:
> MyISAM
>
>
That might be the reason mysql locked in the first place. You get one 
rouge query that takes too long and every other query hitting  that 
table and all joins has to wait for it. InnoDB is a little slower, but 
it ill only lock rows affected by the query instead of the whole 
table/tables. Unless you are index text columns i would recommend 
switching to Innodb or setting up a watchdog on your process list. Most 
times the watchdog is a good move just so you have time to get innodb 
running (select * statements will all need to get paired down to the 
minimum)