… 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… 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… the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench…
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 … even less space (you will see that from results of benchmarks). As you can see from description on Dell site you… it also Now to numbers and benchmarks. All details available here. I used sysbench fileio benchmark for tests (full script available under…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… on the process of alignment, if you’re curious about benchmark results, here they are. What is IO alignment I would… the partition table. On the system that I have been benchmarking, defaults worked out just fine because I was using a… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… run every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark, I used… have ran the same benchmark on. As I mentioned earlier, each of those were run twice – first with RAID controller cache set… 23%. OLTP benchmark results From this benchmark, I only have two graphs to show you. First one is with RAID controller set to…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… I started a series of posts showing benchmark results on Amazon EC2 servers with RAID‘ed EBS volumes and MySQL, versus RDS… on RDS may not be the most advanced available. My benchmarks generally showed that I was not able to outstrip RDS… it is to Percona Server. I haven’t run extensive benchmarks against RDS 5.5, Percona Server 5.5, and MySQL…
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
… CentOS / Kernel. The full results, scripts and settings are on Benchmarks Wiki. * Hardware: Dell PowerEdge R900 * IO subsystems * RAID10: 8 disks… and ib_logfile* are placed on separate RAID partition ( not on FlashCache or SSD) * Benchmark: sysbench oltp ( read-only and read-write… generation has better performance characteristics ( I will post sysbench fileio benchmarks). Also what is attractive in X25-M, that even in…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… fit into cache partition). Please note in this configuration the benchmark is very write intensive, and it is not going be… limited by RAID. So all performance benefits will come from read hits The full report and results are available on benchmark Wiki http://www.percona.com/docs/wiki/benchmark:flashcache:tpcc:start. Short version of results are on graph: In summary: on RAID…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… say you have a server with standard hardware RAID setup running conventional HDDs. RAID setup For the sake of simplicity you create… out there that discuss RAID minutia. Make sure you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU… on both the theory of Aligning IO on hardware RAID and some good benchmarks to emphasize the point, go read those if…
Post: Dissection of EC2 / EBS volume
August 7, 2009 By 4 Comments
… am speaking about single volume, not RAID as in my previous post). Yasufumi did some benchmarks and pointed me on interesting behavior…. Let me show you. I did sysbench random read IO benchmark on files with size from 256M to 5GB with step… as from single HDD, and you may consider some RAID setup, see my previous post EC2/EBS single and RAID volumes IO benchmark
