MySQL Forums
Forum List  »  Performance

1 long query stuck all other queries
Posted by: Jack Wang
Date: September 12, 2012 02:23AM

Hi All

my case is as below:
because of my database size, if there is a long query running.
let's say it running more than 5 hours, then all my other simple queries seems to go very slow.
could someone explain to me about this, and how to solve it?
thanks so much.

Options: ReplyQuote


Subject
Views
Written By
Posted
1 long query stuck all other queries
2403
September 12, 2012 02:23AM
761
September 16, 2012 09:05PM
838
September 16, 2012 10:49PM
809
September 17, 2012 12:48AM
806
September 17, 2012 08:55AM
866
September 14, 2012 01:43AM
822
September 14, 2012 10:36PM


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.