The link http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running mysqlslap …-14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10 for…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… from FusionIO 320GB MLC benchmarks. For benchmarks I used sysbench fileio benchmark. All raw results are available on Percona benchmarks wiki, there I will… raids show worse results than card connected as single devices (you can see results on http://www.percona.com/docs/wiki/benchmark:ssd:start, in summary table, randwr rows) 3. For cards connected in hardware raids, DEADLINE performs much…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…-in-tpcc-mysql-benchmark/. Now I want to test this card against RAID over spinning disks. Benchmark date: Sep-2012 Benchmark goal: Test Intel… RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h for SSD, 4h for HDD RAID, but…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see… used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with next… EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not show benefits comparing with others, and…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…) Xeon(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space…: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark: For the benchmark I took a sysbench uniform oltp rw workload. 256… to investigate later. The scripts and raw results are on Benchmarks Launchpad. Follow @VadimTk !function(d,s,id){var js,fjs…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
In benchmarks passion (see my two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E… for SSD (note it is single device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is… price/performance parameter. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5″ 15K RPM…
Post: Intel 520 SSD in MySQL sysbench oltp benchmark
May 21, 2012 By 11 Comments
In my raw IO benchmark of Intel 520 SSD we saw that the drive does … it affect workload if it comes from MySQL. I prepared benchmarks results for Sysbench OLTP workload with MySQL running on Intel… on this card and use write cache from RAID controller (i.e. LSI-9260). Benchmarks specification, hardware, scripts and raw results are…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… moving parts – it’s XFS alignment by RAID strip size, XFS aligned file allocation, raid partition should be created aligned by 16K… full details are there http://www.percona.com/docs/wiki/benchmark:flashcache:sysbench:300mln_rows:start And short results: buffer_pool… quite impressive. Of course you do not have to believe benchmarks, so I encourage you to test yourself (my full scripts…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short conclusion, RAID10… mode with n2 layout Latest mode you can get creating RAID as: mdadm –create –verbose /dev/md0 –level=10 –layout=n2… regular hard drives or SSD disks. The performance drop in RAID settings is unexpected. I am working with Fusion-io engineers…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
… if the card is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql… RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h, but the result…
