MySQL Forums
Forum List  »  Performance

Re: 1 long query stuck all other queries
Posted by: Jørgen Løland
Date: September 13, 2012 01:56AM

Hi Jack,

It is not surprising that the performance decreases for queries run concurrently with a long-running query. There are all sorts of issues that may be involved:

For example:
* The simple queries have to share hardware resources with the long running query
* There may be concurreny issues like locking conflicts between the queries.

I think the first step is to figure out if we can do anything to improve performance of the long-running query. To do that we need:

* MySQL version
* SHOW CREATE table -- for all involved tables
* An estimate of the number of rows in each of these tables
* EXPLAIN SELECT -- for the long-running query

Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2575
September 12, 2012 02:23AM
Re: 1 long query stuck all other queries
968
September 13, 2012 01:56AM
855
September 16, 2012 09:05PM
961
September 16, 2012 10:49PM
902
September 17, 2012 12:48AM
896
September 17, 2012 08:55AM
956
September 14, 2012 01:43AM
918
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.