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

Written By
slow query makes MySQL halt
February 02, 2009 10:52AM
February 03, 2009 12:40AM
February 04, 2009 03:09AM
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.