…. So I decided to use sysbench and plot some graphs to compare the O_DIRECT performance of ext4 and XFS on the… developments in the XFS world have greatly enhanced the metadata performance of XFS (especially with regards to metadata fragmentation), so maybe…, or using nobarrier, all have no statistically significant impact on performance, which seems to indicate that XFS had some bottleneck internally…
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
… for 4 seconds out of 10 completely and when perform with normal performance the rest of time. The fact drops are relatively… interesting to plot the graph of 95% response time (which sysbench provides) for each of 10 second intervals too. This would…
Comment: Testing Intel SSD 520
May 2, 2012 By 7 Comments
Can you benchmark actual MySQL performance on the SSD? Not sure how well sysbench results translate into actual MySQL results.
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…. There are results for “single file” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread…: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is a signal… > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total-size=${size}G –file-test-mode…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…, it is an enterprise grade storage. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as… particular IO block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… why I decided to test it. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as… particular IO block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
… the prototype patch I wrote to fix the overwrite DIO performance problem: http://oss.sgi.com/archives/xfs/2012-02/msg00219…, I can move forward with this fix. I ran the sysbench tests to check this was the problem – I don’t… contention is killing XFS as the thread count grows. ext4 performance shows that it uses exclusive locking as well, but it…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…: randgen (lp:randgen), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… performance by having many outstanding requests. Running with more than one threads you may also take a look at another table SysBench…-test-mode=rndwr cleanup sysbench v0.4.8: multi-threaded system evaluation benchmark Removing test files… [root@DB10 sysbench]# ./sysbench –test=fileio –max…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… would like to see is performance is staying about the same when we run tests concurrently because Sysbench should run completely in… takes about 180 seconds. Yes you get it right. Performance of sysbench OLTP on small table drops more than 150 times when… to measure small variances in performance reliably. Running Sysbench and MySQLDump convurrently gives about 325 req/sec for sysbench and some 100 seconds…
