MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 update doubled IOs
Posted by: Dimitri Kravtchuk
Date: March 29, 2013 06:30AM

Hi Christian,

no, optimizer trace feature is available only since MySQL 5.6

the most strange for me that even when the same execution plan is used (in STAR-COUNT) there is still a difference in response time, and mainly is coming from the data sending (and it's in both cases)..

so, just to clarify:
- do you run all these queries on the same HW (same server?)
- were the tables created in the same manner? (same indexes, engines, charsets, etc.)

is there any way you can provide us a reproducible test case?..

Rgds,
-Dimitri

Options: ReplyQuote


Subject
Views
Written By
Posted
1275
March 20, 2013 08:52AM
1177
March 27, 2013 11:44PM
Re: MySQL 5.6 update doubled IOs
1396
March 29, 2013 06:30AM
1209
March 28, 2013 07:49PM
1135
April 02, 2013 12:20AM
1184
April 02, 2013 09:57PM
1155
April 10, 2013 08:31AM


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.