Re: MySQL 5.6 update doubled IOs
Posted by:
Rick James
Date: March 20, 2013 08:52AM
Your graphs show only 5.6? What was it like with 5.5?
The long-standing problem was that InnoDB transactions-per-second would periodically drop to almost literally zero for a second or so.
Percona's XtraDB has one solution; Oracle's 5.6 has a different solution. XtraDB has the solution in their 5.5 (and may have had it in previous versions). I have seen several independent graphs showing that the problem is solved in XtraDB.
I don't know if what I am describing matches your problem or the bug report. Mark Callaghan is an expert in InnoDB performance.
Subject
Views
Written By
Posted
3391
March 18, 2013 08:33AM
1371
March 19, 2013 08:58AM
Re: MySQL 5.6 update doubled IOs
1342
March 20, 2013 08:52AM
1340
March 21, 2013 09:51AM
1430
March 26, 2013 08:29AM
1410
March 27, 2013 11:11AM
1246
March 27, 2013 11:44PM
1270
March 28, 2013 02:17AM
1314
March 28, 2013 09:55AM
1908
March 29, 2013 02:20AM
1473
March 29, 2013 06:30AM
1391
March 29, 2013 06:56AM
1299
March 29, 2013 07:18AM
1254
March 29, 2013 07:49AM
1306
March 29, 2013 08:08AM
1290
March 29, 2013 10:07AM
1277
March 28, 2013 07:49PM
1321
March 29, 2013 01:23AM
1207
April 02, 2013 12:20AM
1257
April 02, 2013 12:30AM
1378
April 02, 2013 12:44AM
1219
April 02, 2013 02:23AM
1255
April 02, 2013 09:57PM
1315
April 03, 2013 12:46AM
1496
April 03, 2013 03:29AM
1267
April 05, 2013 01:57AM
1330
April 05, 2013 06:24AM
1227
April 10, 2013 08:12AM
1226
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.