MySQL Forums
Forum List  »  Performance

Queries suddenly too slow
Posted by: sainandoor
Date: June 06, 2005 07:02PM

Hello,
I am new to MySQL. I am using version 5.0.4. I noticed that suddenly my queries were becoming too slow. I have data in three tables, with 40,000 rows, 50,000 rows and 70,000 rows respectively. I was able to run queries that joined the three tables together and get the results in less than 5 seconds. I tried updating the tables through a program that used a stored procedure to delete the tables but I had some other problems. Since the I restored the data in the tables from backup databases. Now I can't run any queries that join the three tables together, it waits for a long time and then times out. The data in the tables look good. Now I can't get the results from any of the other backup databases either. It look like the entire MySQL server has slowed down greatly. I tried rebooting the server to no avail. I don't know what to do. Help is greatly appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Queries suddenly too slow
5118
June 06, 2005 07:02PM
2260
June 06, 2005 07:49PM
2088
June 06, 2005 07:56PM
2170
June 07, 2005 04:38AM
1851
June 06, 2005 07:58PM
1813
June 06, 2005 08:00PM
1767
June 07, 2005 10:25AM
1945
June 07, 2005 07:10PM


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.