Re: Why is my entire database getting locked for a slow select query?

[Derek Krzanowski]

Thanks for the info... I put in your recommendations with one exception, the innodb_log_file_size option is causing innodb to fail startup no matter how I specify it. I tried everything from 256M to 1024M as well as specifying it in bytes and no matter what I do, I get errors on all my innodb tables after I restart mysql with that setting in my.cnf... I ended up leaving the rest of the settings you recommended in and I also increased key_buffer as well since we have a lot of myisam as well (my total buffers for all engines is 50% so well under the 80% recommended max). Everything was great for about an hour with no insert hangs at all and now they have suddenly started to happen again with no obvious explanation...