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?
Subject
Views
Written By
Posted
3317
March 18, 2013 08:33AM
1335
March 19, 2013 08:58AM
1306
March 20, 2013 08:52AM
1294
March 21, 2013 09:51AM
1396
March 26, 2013 08:29AM
1375
March 27, 2013 11:11AM
Re: MySQL 5.6 update doubled IOs
1205
March 27, 2013 11:44PM
1231
March 28, 2013 02:17AM
1271
March 28, 2013 09:55AM
1854
March 29, 2013 02:20AM
1433
March 29, 2013 06:30AM
1335
March 29, 2013 06:56AM
1250
March 29, 2013 07:18AM
1219
March 29, 2013 07:49AM
1256
March 29, 2013 08:08AM
1249
March 29, 2013 10:07AM
1243
March 28, 2013 07:49PM
1279
March 29, 2013 01:23AM
1171
April 02, 2013 12:20AM
1221
April 02, 2013 12:30AM
1339
April 02, 2013 12:44AM
1184
April 02, 2013 02:23AM
1216
April 02, 2013 09:57PM
1281
April 03, 2013 12:46AM
1465
April 03, 2013 03:29AM
1226
April 05, 2013 01:57AM
1278
April 05, 2013 06:24AM
1180
April 10, 2013 08:12AM
1188
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.