Query slows down over time
Hi,
One of my queries on mysql (it joins 4 tables) tends to get slow after some days. It normally executes in about less than a second. However after some days it takes a long time and sometimes forever to execute. I have to restart mysql and then the query executes again normally in less than a second. At an average 2 of the 4 tables contain about 3 million rows. There are indexes on these tables.Any inputs from will be helpful as I cant keep restarting mysql every week or so.
Thanks.
Subject
Views
Written By
Posted
Query slows down over time
2337
May 28, 2014 09:35AM
1185
May 28, 2014 12:45PM
1032
May 28, 2014 01:24PM
1119
May 28, 2014 04:57PM
1169
May 28, 2014 05:46PM
1110
May 28, 2014 07:23PM
3698
May 29, 2014 05:38AM
1438
May 29, 2014 09:49AM
1281
May 29, 2014 03:12PM
1379
July 15, 2014 12:10PM
1126
July 15, 2014 12:33PM
1042
July 16, 2014 11:19AM
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.