… all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse… average results: RAID10 – 7439.850 TPM SSD – 10681.050 TPM FusionIO – 17372.250 TPM However what should be noted – both SSD and FusionIO… (see my post http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… see 8 individual cards. Card configured in software RAIDs: RAID0, RAID10, RAID5, RAID50 In second round (marked as hardware) each Adaptec… see 2 devices. Devices connected in software RAIDs: RAID0 and RAID10 with different OS schedules over each device. I should highlight… say With SSD drives you can get decent results for random and sequential reads. I think it is competitive vs FusionIO if…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… regular RAID10 with regular hard drives, here I followed Yoshinori Matsunobu’s recommendations http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd… thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions…
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
I posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The … in full report. For reference I show also results for RAID10 on 8 disks, 2.5″ , 15K RPMS each. Random reads… we can see only 130MB/sec max throughput. Write bandwidth vs filesize: So there I tested how filesize (fill factor) affects…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
…. For curiosity I run the same benchmarks on ext3 vs xfs on SSD card, the results are: Interesting facts: – xfs is 25% faster ext3 – the gaps on SSD is more visible than on RAID10… xtradb or xfs problem, and why it appears only on RAID10, but not SSD.
Comment: FlashCache: tpcc workload
May 26, 2010 By 18 Comments
… in systems that allows many outstanding IO requests ( RAID10, SSD) CFQ just dies vs Deadline in OLTP workloads. See for example http://www…
