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)
/* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
