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
5293
February 02, 2009 10:52AM
2146
February 03, 2009 12:40AM
2128
February 04, 2009 03:09AM
2078
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.