# MySQL 5.0.67 is faster than 5.5.15 **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [September 26, 2011, 6:58am UTC](https://forums.percona.com/t/mysql-5-0-67-is-faster-than-5-5-15/1676 "2011-09-26T06:58:33Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![DenisM](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DenisM](https://forums.percona.com/u/DenisM)\ **Post date:** [September 26, 2011, 6:58am UTC](https://forums.percona.com/t/mysql-5-0-67-is-faster-than-5-5-15/1676/1 "2011-09-26T06:58:33Z")
Hi, I compare performance of 5.0 and 5.5 at FreeBSD 7.4. I have two identical servers: 2x X5687 3.6GHz 98GB 8x HDD 146GB RAID at srv01: Id Size Level Stripe State Cache Name mfid0 ( 544G) RAID-1 64K OPTIMAL Writes RAID at srv02: Id Size Level Stripe State Cache Name mfid0 ( 952G) RAID-5 128K OPTIMAL Writes I run sysbench as follows: MyISAM warmup: –test=oltp --mysql-db=test --oltp-table-name=sbtest\_myisam --max-time=120 --max-requests=0 --num-threads=8 --mysql-socket=/tmp/mysql.sock --oltp-read-only=on run MyISAM r/o test: –test=oltp --mysql-db=test --oltp-table-name=sbtest\_myisam --max-time=60 --max-requests=0 --num-threads=$i --mysql-socket=/tmp/mysql.sock --oltp-read-only=on run InnoDB warmup: –test=oltp --mysql-db=test --oltp-table-name=sbtest\_innodb --max-time=120 --max-requests=0 --num-threads=8 --mysql-socket=/tmp/mysql.sock --oltp-read-only=on run InnoDB r/o test: –test=oltp --mysql-db=test --oltp-table-name=sbtest\_innodb --max-time=60 --max-requests=0 --num-threads=$i --mysql-socket=/tmp/mysql.sock --oltp-read-only=on run InnoDB r/w test: –test=oltp --mysql-db=test --oltp-table-name=sbtest\_innodb --max-time=60 --max-requests=0 --num-threads=$i --mysql-socket=/tmp/mysql.sock run What I get is 5.5 defeat: num-threads 1 2 3 4 5 6 7 8 10 12 14 16 18 20 22 24 26 28 30 32 36 40 44 48 52 56 60 64srv01: MySQL 5.0.67MyISAM-RO, tps 426.71 725.57 973.66 1156.96 1272.73 1226.91 1139.41 1037.77 887.3 753.07 627.38 523.83 462.76 400.93 348.95 302.41 289.03 259.91 251.23 234.1 216.87 198.67 194.87 185.09 182.66 176.76 173.1 170.83InnoDB-RO, tps 340.64 677.72 1003.94 1322.52 1579.73 1805.14 2011.87 2216.72 2452.15 2644.93 2807.23 2902.67 2812.12 2738.45 2691.59 2668.98 2654.41 2649.93 2641.42 2619.1 2601.82 2567.7 2456.73 2429.16 2328.02 2285.03 2210.29 2181.58InnoDB-RW, tps 282.55 538.73 757.27 977.01 1169.77 1330.55 1466.86 1575.6 1735.46 1786.18 1761.36 1757.96 1741.73 1722.25 1658.2 1610.09 1583.49 1582.79 1566.43 1547.11 1478.27 1246 1177.73 786.99 753.66 516.18 627.72 683.74srv02: MySQL 5.5.15MyISAM-RO, tps 415.05 716.39 953.74 1164.5 1252.94 1178.99 1054.93 938.62 895.02 813.39 698.7 592.76 537.41 509.51 491.63 473.91 461.51 448.63 438.83 429.39 414.73 398.43 391.88 418.6 473.02 532.58 585.42 633.26InnoDB-RO, tps 329.41 644.44 942.18 1270.56 1536.27 1817.91 2091.28 2360.85 2253.96 2235.38 2227.67 2230.93 2249.48 2257.12 2262.33 2267.69 2277.28 2281.22 2283.75 2282.72 2289.74 2291.23 2289.82 2290.47 2289.81 2286.34 2284.71 2281.92InnoDB-RW, tps 263.08 500.49 725.2 958.81 1141.32 1295.54 1440.64 1557.53 1607.25 1611.72 1619.78 1617.16 1568.26 1417.52 1419.97 1415.19 1400.13 1401.08 1315 1309.76 1302.36 1280.06 1271.39 1259.55 1245.41 1240.26 1218.8 1199.69 What is a possible reason: misconfiguration, OS, RAID, something else? The following my.cnf is used: back\_log = 100binlog\_cache\_size = 1Mconnect\_timeout = 5delayed\_insert\_limit = 10000delayed\_insert\_timeout = 100delayed\_queue\_size = 8000000expire\_logs\_days = 5ft\_min\_word\_len = 4innodb\_additional\_mem\_pool\_size = 20Minnodb\_buffer\_pool\_size = 40Ginnodb\_data\_file\_path = ibdata1:10M:autoextendinnodb\_flush\_log\_at\_trx\_commit = 1innodb\_flush\_method = O\_DIRECTinnodb\_lock\_wait\_timeout = 300innodb\_locks\_unsafe\_for\_binlog = 1innodb\_log\_buffer\_size = 16Minnodb\_log\_file\_size = 1900Minnodb\_status\_file = 0innodb\_thread\_concurrency = 0interactive\_timeout = 120join\_buffer\_size = 1Mkey\_buffer\_size = 6Gmax\_allowed\_packet = 1Mmax\_connect\_errors = 10max\_connections = 200max\_heap\_table\_size = 64Mmax\_user\_connections = 200myisam\_sort\_buffer\_size = 4Gskip-external-lockingskip-name-resolvesort\_buffer\_size = 64Ksync\_binlog = 1table\_cache = 2048thread\_cache\_size = 286thread\_stack = 196Ktmp\_table\_size = 64Mtransaction\_isolation = REPEATABLE-READwait\_timeout = 120 ---
**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\ **Post date:** [September 26, 2011, 7:46am UTC](https://forums.percona.com/t/mysql-5-0-67-is-faster-than-5-5-15/1676/2 "2011-09-26T07:46:34Z")
Could you check the performance of your disks? In particular, I’m curious about how you got 544G with RAID1. RAID10 is faster than RAID5, in general. ---
**Author:** ![DenisM](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DenisM](https://forums.percona.com/u/DenisM)\ **Post date:** [September 27, 2011, 1:02am UTC](https://forums.percona.com/t/mysql-5-0-67-is-faster-than-5-5-15/1676/3 "2011-09-27T01:02:30Z")
Please, what role can play disks in memory-bound test? Nevertheless, $ iostat -dx 5 extended device statisticsdevice r/s w/s kr/s kw/s wait svc\_t %bmfid0 0.8 63.5 8.6 2799.4 0 0.8 1 extended device statisticsdevice r/s w/s kr/s kw/s wait svc\_t %bmfid0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statisticsdevice r/s w/s kr/s kw/s wait svc\_t %bmfid0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statisticsdevice r/s w/s kr/s kw/s wait svc\_t %bmfid0 0.0 2.8 0.0 44.8 0 0.2 0 extended device statisticsdevice r/s w/s kr/s kw/s wait svc\_t %bmfid0 0.0 3.4 0.0 9.2 0 0.1 0