MySQL Forums
Forum List  »  Performance

slow query makes MySQL halt
Posted by: Erel Segal
Date: February 02, 2009 10:52AM

When I run a SELECT query that takes a lot of time, with joins on large tables, it causes all other MySQL commands to wait. Even a simple "show processlist" command waits until the SELECT finishes.

It seems that mysqld spends all its time on the SELECT.

Is there a way to solve this problem?

Options: ReplyQuote


Subject
Views
Written By
Posted
slow query makes MySQL halt
5127
February 02, 2009 10:52AM
2071
February 03, 2009 12:40AM
2045
February 04, 2009 03:09AM
2000
February 04, 2009 11:16AM


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.