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?
Subject
Views
Written By
Posted
slow query makes MySQL halt
5304
February 02, 2009 10:52AM
2150
February 03, 2009 12:40AM
2132
February 04, 2009 03:09AM
2082
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.