MySQL Forums
Forum List  »  Performance

Re: Why does MySQL's performance decrease when queries are executed in parallel?
Posted by: dmitry kotelnikov
Date: July 05, 2012 10:56AM

Rick, thanks a lot for the explanation. I'm already using the XtraDB engine so the issue is not related to InnoDB. For the moment I tend to think that this sort of unscalable behaviour is due to a bottleneck of some kind that happens during quereing MySQL. The most probable reason is heavy memory usage which about 7000 hits for a single query totalling into 700,000 hits a second (as was suggested on StackOverflow, here's the related link: http://stackoverflow.com/a/11341343/1200148)

Options: ReplyQuote




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.