MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 update doubled IOs
Posted by: Dimitri Kravtchuk
Date: April 03, 2013 03:29AM

All,

since I was able to reproduce the "test case", seems like things are not as simple.. - on my server MRR is enabled, however OPTIMIZER is not using it in the execution plan (I have only "Using index condition" without "Using MRR").. So, we have yet to understand why in Christian's case it's not the same..

while for the difference in SELECT count(*) -- the overhead is coming from PFS (Performance Schema). So, as a general advice, to have a "pure" compare of 5.5 vs 5.6 think to start 5.6 with "performance_schema = OFF". However, in most cases you may need just to disable "default instrumentation", so just start with:
performance_schema = ON
performance_schema_instrument = '%=off'

this will keep PFS on, and still give you a way to dynamically enable different instrumentations when you need.. In this particular case the overhead came from the table IO instrumentation (have no idea yet why it can be so big here, but this must be fixed for sure).. - with PFS=off (or none) on my server I have a even better execution time on 5.6 than on 5.5 BTW ;-)

Rgds,
-Dimitri

Options: ReplyQuote


Subject
Views
Written By
Posted
1258
March 20, 2013 08:52AM
1165
March 27, 2013 11:44PM
1194
March 28, 2013 07:49PM
1122
April 02, 2013 12:20AM
1170
April 02, 2013 09:57PM
Re: MySQL 5.6 update doubled IOs
1430
April 03, 2013 03:29AM
1142
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.