… 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
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… drive so no software RAID is necessary. To compare performances I ran sysbench oltp and tpcc-mysql benchmarks. I will present the… adequately fill both cards in comparison. Some hardware used in benchmarks include: Server: Cisco UCS C250, running Oracle Linux 6.1…_log_at_trx_commit=1 As in all my recent benchmarks, I use long runs of 1 hour each with measurements…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… in data reliability: if a single module fails, the internal RAID will allow to continue operations, and after the replacement of… to most interesting part – performance numbers. I took sysbench fileio benchmark with 16KB blocksize to see what maximal performance we can… to have aligned IO requests) and mounted with nobarrier option Benchmark: sysbench fileio on 100GB file, 16KB blocksize The raw results…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… is not tested at all… control_io-threads.patch Generally RAID storage can parallelize IO accesses to several disks. This patch…_file_io_threads = 10″ for almost all RAID storages. The more disks the RAID have, the bigger number may make sense. * This… the insert buffer) In conclusion, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6 use the… conclusions. These will be the topic of further blog posts. Benchmark Details: The SSB employs a data generator which produces data… cores). 12GB memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5…
Post: L2 cache for MySQL
October 25, 2012 By 13 Comments
… a quick benchmark on tpcc-mysql 2500W (250GB), I used data on RAID data on SSD (Intel SSD 910) data on RAID with…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… usually for benchmarks I used our workhorse Dell PowerEdge R900 with 16 cores and 32GB of RAM and RAID 10 on 8… connection. For in-memory benchmark I set InnoDB buffer pool to 16GB, and for io-bound benchmarks I made it 3GB. Raw…-zNeXwe2k3Og And let me post some graphs here. In-memory benchmark, results during run: And averaged final result: As you see…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 21 Comments
… be connected together via software RAID. So I tested in two modes: single drive, and software RAID-0 over two drives. I… graph I show the results for both single card and raid (Duo). Random writes, async: We see stable and predictable write…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 26 Comments
… for MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes… metadata fragmentation), so maybe it’s time to do another benchmark. What I found with XFS is that, to my great… of allocation groups, setting the correct sunit/swidth for the RAID array, or using nobarrier, all have no statistically significant impact…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… we made research of scalability problems in sysbench write workload (benchmark emulates intensive insert/delete queries). By our results the problem… it. I rerun benchmarks on different server (Dell PowerEdge R900, 16-way Intel Xeon, 32GB of RAM, RAID 10 on 8 disks…-name-resolve table_cache=2048 sysbench parameters /data/vadim/benchwork/benchmarks/sysbench/bin/sysbench –num-threads 1 –max-requests 0 –max…
