June 20, 2013

Post: RAID vs SSD vs FusionIO

…) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on…/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it is single device, in comparison to RAID… TPM on price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM / $ Please note…

Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks

….com/docs/wiki/benchmark:ssd:start, in summary table, randwr rows) 3. For cards connected in hardware raids, DEADLINE performs much worse… can get pretty decent results from SSD (230MB/sec on 4+ threads) – Cards connected in hardware raid is doing much better – DEADLINE… say With SSD drives you can get decent results for random and sequential reads. I think it is competitive vs FusionIO if…

Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark

…: Seagate ST9750420AS 750GB, 2.5″, 7200RPM, 16MB, SATA. Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12…: 2500W (~250GB of data) Benchmark length: 2h for SSD, 4h for HDD RAID, but the result is taken only for last 1h… performance gain. Or in text form: BP sizeHDD RAIDIntel SSD 910Ratio (i910/raid) 25 GB22816207.1 50 GB55231825.76 75 GB109457295.24…

Comment: How many fsync / sec FusionIO can handle

… current fsync test, FusionIO is 72% faster than 8 disk RAID In your random write test earlier (http://www.mysqlperformanceblog.com… disk RAID In your tpm test (http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd-vs-fusionio/ ) FusionIO is 134% faster than 8 disk RAID

Post: Intel 520 SSD in MySQL sysbench oltp benchmark

…. There I want to publish graphs to compare Intel 520 vs regular RAID10. Throughput: Response time: So despite big variation in… significantly, and single Intel 520 SSD gives much better throughput and response time comparing with traditional SAS RAID, and what is interesting… write cache on this card and use write cache from RAID controller (i.e. LSI-9260). Benchmarks specification, hardware, scripts and…

Comment: MySQL 5.5.8 and Percona Server: being adaptive

… direct comparison FusionIO vs HDD, you can see some data there http://www.mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/ and there http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd-vs-fusionio/

Comment: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN

…. WAN vs LAN is one of such as round trip can be 100+ times longer. Other one is HDD without Raid with BBU compared to one with, the difference would be some 200 fsync/sec vs 10.000+ again close to 100x difference. Similar numbers apply to SSD vs HDD The point is…

Post: FusionIO - time for benchmarks

I posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The … we can see only 130MB/sec max throughput. Write bandwidth vs filesize: So there I tested how filesize (fill factor) affects…

Comment: FlashCache: tpcc workload with FusionIO card as cache

… benchmark (like this: http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd-vs-fusionio/) they seem to represent a even better ROI then…

Post: Heikki Tuuri answers to Innodb questions, Part II

…1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a lot of performance differences and…. I’m also wondering if you would recommend using SSD for this purpose, and how much performance gain there… sequential which can be very well taken care of RAID Battery Backed Up cache and when sequentially written to…