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

[Shawn Taylor]

Yes,

Sorry, you can't just jack those around like adding windshield washer to the reservoir.

See this post:

http://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html

Or google the option - innodb_log_file_size - lots of discussion around your errors and how to increase these proper.

At this point I have exhausted my skills. There are folks around the forumns that are much better though. Look through the performance or general forums for posts by Rick James/Peter Brawley/Laptop Alias.

They have a much stronger grasp of how to make the server perform more quickly.

Based on this post:

http://forums.mysql.com/read.php?24,367406,380248#msg-380248

I would turn off your query cache. Not sure why *exactly* but I know there are conditions that can arise that make it more harmful than beneficial.

Plus, you can always turn it back on.

Lastly, I noticed that from your second to third status you had an increase of 113 slow queries. Check the slow query log and identify those. Why are they slow? can they be optimized? Can you achieve the same result in a different way?

Good Luck,

Shawn