… also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-…/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb …=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_…
Post: Linux IO Schedulers and MySQL
January 30, 2007 By 7 Comments
Found a great article about Linux IO Schedulers today which is quite interesting. It goes in details … difference was not really significant. This article also points out benchmarking IO schedulers you should look at more numbers than aggregate bandwidth…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes… –raid-devices=2 /dev/md0 /dev/md1 And also in Linux you can create tricky RAID10,f2 (you can read what… also I tested IO on single volume. I used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…removed some irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | …run every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark, I …
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…XtraDB (all plugins statically compiled in MySQL) For benchmarks I used scripts that emulate TPCC load and…innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_…one. And it is important to remember as Linux kernels 2.6.18+ (which are used on …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…them I would not be able to run benchmarks. Description of benchmark: We used table “normal” table structure which … CPU bound workload in this case (no disk IO) to see how efficient storage engines are in … are described here Used hardware Red Hat Enterprise Linux AS release 4 (Nahant Update 4) 2 Ñ… …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… benchmark results, here they are. What is IO alignment I would like to start with some background on IO alignment. So what is IO… the partition table. On the system that I have been benchmarking, defaults worked out just fine because I was using a… 19535039 9767488+ 83 Linux /dev/sda2 19535040 27342629 3903795 82 Linux swap / Solaris /dev/sda3 27342630 2339835119 1156246245 8e Linux LVM sda1 and…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in sysbench, and now… MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount… 20% better throughput. I am still going to run more benchmark to get better picture. The script for tests: for size…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
… no a reliable way in the Linux asynchronous IO library to get time metrics for particular IO block. so my testing command line… suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If… talk – you are welcome to join the webinar. Disclaimer: This benchmark is done as part of consulting work for STEC, but…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…. However at this point, I have no access to Fusion-io ioDrive2, which is based on 25nm NAND. Another important factor…. To compare performances I ran sysbench oltp and tpcc-mysql benchmarks. I will present the results for sysbench oltp (with full… in comparison. Some hardware used in benchmarks include: Server: Cisco UCS C250, running Oracle Linux 6.1 and Percona Server 5.5…
