mysql issue

Paul Seamons paul at
Wed Feb 8 15:13:23 MST 2012

I'd second that, but I'd add a "be sure to add innodb_file_per_table=1 
to the my.cnf


On 02/08/2012 12:24 PM, Jason Van Patten wrote:
> On 2/8/2012 11:50 AM, Merrill Oveson wrote:
> 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:, #utah on
> Unsubscribe:
> Don't fear the penguin.
> */

More information about the PLUG mailing list