MySQL Forums
Forum List  »  Optimizer & Parser

Executing same query in 1 moment
Posted by: Brano Gerzo
Date: November 19, 2011 09:27AM

Hi all,

I got a problem on highly visited website. Let's say I am caching few of queries, which are quite hard for mysql - let's say some statistics for last month, or few days ago, anyway - they took around 5 seconds to complete, and there is no way to optimize them more.

I run into the problem - I see in mytop, mysql is executing roughly 20 same queries in the same time. Is there some workaround, how to force mysql will execute just one of these queries ? When, there are 20 same queries executed in same time (then they are cached), I got high load on db box, and other queries are blocked (MyISAM).

I am thinking to make some locking into memcache, but I am not sure, if this is right approach. If you got some articles about this problem, post, I will read them.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Executing same query in 1 moment
2411
November 19, 2011 09:27AM
1078
November 20, 2011 04:42PM
1111
November 20, 2011 10:31PM
991
November 22, 2011 12:05AM
1075
November 21, 2011 12:42AM


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.