… posted pretty interesting post about iSCSI vs SCSI performance using SysBench. This is nice to finally see some iSCSI benchmarks done… hardware available for tests. It is also good to see Sysbench being used, as It is developed by our team, even… for example it is log write bound rather than tablespace IO bound, which does not really benefit from multiple hard drives…
Post: Linux IO Schedulers and MySQL
January 30, 2007 By 7 Comments
… several times slower than deadline for MySQL workloads such as SysBench or DBT2 when it went down to 30% difference and… was not really significant. This article also points out benchmarking IO schedulers you should look at more numbers than aggregate bandwidth… for example. It also means you’d better to perform IO scheduler benchmarks on mixed load with different of task, for…
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 9 Comments
Peter, As I mention, I can’t provide response time graph for async IO, sysbench can’t measure time for each IO in async mode.
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… concurrently because Sysbench should run completely in memory and use a lot of CPU resources but none of disk IO and mysqldump…_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table… variances in performance reliably. Running Sysbench and MySQLDump convurrently gives about 325 req/sec for sysbench and some 100 seconds for mysqldump…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… sysbench and tpcc-mysql workloads between FlashMAX 1.4TB and ioDrive Duo 1.28TB. It is important to highlight that Fusion-io…. To compare performances I ran sysbench oltp and tpcc-mysql benchmarks. I will present the results for sysbench oltp (with full report… tpcc-mysql in a followup post. For sysbench, I used our multi-tables sysbench implementation with 256 tables and 10,000,000…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… decided to look into it. I used sysbench fileio test as our concern is general IO performance in this case – it is… become copied and so writes can just proceed normally. /tmp/sysbench –test=fileio –num-threads=1 –init-rng=on –max-time… fsync every 100 writes rather than after each request: /tmp/sysbench –test=fileio –num-threads=1 –init-rng=on –max-time…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize joins. I also… set of data which is more rich than the simple sysbench table. The Star Schema Benchmark (SSB) seems ideal for this… * READ_AHEAD_EVICTED_RATE: 0 LRU_IO_TOTAL: 531 * LRU_IO_TOTAL: 431 LRU_IO_CURRENT: 0 * LRU_IO_CURRENT: 0 UNCOMPRESS_TOTAL: 0…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
…. There are results for “single file” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread… and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in sysbench, and now we can get: ext4… > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total-size=${size}G –file-test-mode…
Post: Dissection of EC2 / EBS volume
August 7, 2009 By 4 Comments
… on EBS volume. Let me show you. I did sysbench random read IO benchmark on files with size from 256M to 5GB… 1; do echo PARAMS $size $mode $threads > sysbench-size-$size-mode-$mode-threads-$threads ./sysbench –test=fileio –file-total-size=${size}M… –file-fsync-freq=0 run \ >> sysbench-size-$size-mode-$mode-threads-$threads 2>&1 done ./sysbench –test=fileio –file-total-size=${size…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
…, it is an enterprise grade storage. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as… the Linux asynchronous IO library to get time metrics for particular IO block. so my testing command line looks like: sysbench –test=fileio… it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16…
