Re: Queries suddenly too slow

[Benoit St-Jean]

sainandoor wrote:
> 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.

Can you post the DESCRIBE for those 3 tables, a SHOW INDEX for those tables and the EXPLAIN for the problem query?