I have queries that sporadically take a very long time
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.
Subject
Views
Written By
Posted
I have queries that sporadically take a very long time
3531
February 21, 2009 04:23PM
1866
February 21, 2009 10:33PM
2013
February 22, 2009 09:48AM
2535
February 22, 2009 12:44PM
1697
March 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.