MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 update doubled IOs
Posted by: Rick James
Date: March 28, 2013 07:49PM

That link shows the fields, but not the indexes.

How big is the table (SHOW TABLE STATUS -- both 5.5 and 5.6)? What are the details (SHOW CREATE TABLE -- both 5.5 and 5.6)?

> Feel free to buy it and test it :)

No thanks. It has several flaws. Many are addressed here:
http://mysql.rjweb.org/doc.php/ipranges

And they don't handle IPv6.

Meanwhile, I suggest you write a bug report that says that 5.6's MRR can degrade performance.

Options: ReplyQuote


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