MySQL Forums :: Performance :: I have queries that sporadically take a very long time


Advanced Search

I have queries that sporadically take a very long time
Posted by: Stephan Tual ()
Date: February 21, 2009 04:23PM

Hi, basically my problem is as follow:

Our web server server processes around 24 queries per second. My slow query log is set to track the ones taking longer than 5 seconds. It only picks up maybe 20 queries a day taking longer than that.

The problem is that these query instances take 60+ seconds to run when they run slow, and they cause our server to 'freeze'. It's bizarre, because they are properly indexed and I can execute them manually without any issue. In fact, they are run regularly during the day without any problem, except for these rare instances.

I understand how an improperly indexed query can run slow. I don't understand how an optimized one can run well (read: 10ms) 99.99% of the time , and when running slow, take so long.

Is there a way for me to figure out what's going on?



Edited 1 time(s). Last edit at 02/21/2009 04:25PM by Stephan Tual.

Options: ReplyQuote


Subject Views Written By Posted
I have queries that sporadically take a very long time 2703 Stephan Tual 02/21/2009 04:23PM
Re: I have queries that sporadically take a very long time 1586 Rick James 02/21/2009 10:33PM
Re: I have queries that sporadically take a very long time 1655 Stephan Tual 02/22/2009 09:48AM
Re: I have queries that sporadically take a very long time 1802 Rick James 02/22/2009 12:44PM
Re: I have queries that sporadically take a very long time 1531 Stephan Tual 03/01/2009 10:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.