… http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running …seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a … –concurrency=25,50,100,200,500,1000,2000 –iterations=10 –number-int-cols=6 –number-char-cols=6 –…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server… 23%. OLTP benchmark results From this benchmark, I only have two graphs to show you. First one is with RAID controller set to…
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 worth… price/performance parameter. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5″ 15K RPM disks…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is….xfs -s size=4096, mount -o nobarrier Benchmark: For the benchmark I took a sysbench uniform oltp rw… best possible gain. I do measurements every 10 sec to see stability of results. Graphical result…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. … NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT NULL, PRIMARY KEY (`l_orderkey`,`l_linenumber`), KEY `lineitem…. As you see 1285 rkB/s is pretty small for RAID 10 system we have on this server. This is because of…
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
… check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB… our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS 2.5″ 15K RPM disks). For comparison… Spreadsheet (it is also being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph there: Results…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… is long over, but still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details… configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration… the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… table. On the system that I have been benchmarking, defaults worked out just fine because I was …. Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB… partition table. RAID stripe Further down below on the storage stack there’s a group of RAID stripe …
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… here http://www.mythtv.org/wiki/RAID) mdadm -C /dev/md0 –chunk=256 -n 4 -l 10 -p f2 /dev/sdj /dev… used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with next…
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…-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h for SSD, 4h for HDD RAID, but… Results There is a jitter graph of Throughput taken every 10 sec: I put number of median throughput, so we can…
