MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Why does MySQL's performance decrease when queries are executed in parallel?
Posted by: dmitry kotelnikov
Date: June 28, 2012 12:23PM

Aftab Khan, thank you for your answer. I also found that double key works longer than single. But the question is why for query with NON-EXISTENT keys works much longer than query with EXISTENT keys for the same table and same row count (see in my question). And what can be the reason of strange behaviour when concurrent. Why query with NON-EXISTENT keys overal performance not increased, but even decreased when running in concurrent, while query with EXISTENT keys performance increased.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.