I'd second that, but I'd add a "be sure to add innodb_file_per_table=1 to the my.cnf
Paul On 02/08/2012 12:24 PM, Jason Van Patten wrote: > 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. > */ > /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
