MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 update doubled IOs
Posted by: Rick James
Date: March 27, 2013 11:44PM

> Our DEVs told me they altered 3 tables from MyISAM to InnoDB after the upgrade.

Let's see the CREATE TABLEs for them, plus any queries on those tables that are now slow.

You have the slowlog turned on; please provide the busiest queries. Recommend pt-query-digest for summarizing.

> About 1G in total.

Probably grew by 3x after the conversion.

ext4 is sub-optimal for MySQL.

> table_open_cache = 50000
Terribly high. 500 would probably be better. The unit is 'table', not 'bytes'.

> slave-skip-errors = all
Ouch.

Were the 5.5 settings the same as the 5.6?

Options: ReplyQuote


Subject
Views
Written By
Posted
1255
March 20, 2013 08:52AM
Re: MySQL 5.6 update doubled IOs
1160
March 27, 2013 11:44PM
1191
March 28, 2013 07:49PM
1115
April 02, 2013 12:20AM
1166
April 02, 2013 09:57PM
1138
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.