Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

whenever I make a new request in my application it takes to long to respond for the first time and all the subsequent requests are faster. If I do it again after some hours or tomorrow again it takes more time to respond and same subsequent requests respond quickly. I am not sure why this is happening every now and then even though the server is not restarted. I can understand if it is issue of explain plan creation. But the explain plan is created only once for the first time and it should not be slow there after. But I am keep on experiencing periodically even though the server is not restarted.

share|improve this question

marked as duplicate by RolandoMySQLDBA, Phil, Max Vernon, Shawn Melton, Mark Storey-Smith Dec 12 '13 at 9:22

This question was marked as an exact duplicate of an existing question.

If it is caching issue, my query should be faster after the first time. But if I run the same query after couple of hours or after a day again I experience the this behavior. – user1614862 Dec 11 '13 at 17:30
@user1614862 the data will have been aged out of the cache. LRU – Phil Dec 12 '13 at 0:10