… posting the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card…’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… is long over, but still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details… about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code… noticed that the insert rate drop was mainly caused by IO pressure caused by increase in flushing and checkpointing activity. This…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… test it under MySQL workload, but before getting to that, let me review the same workload on Fusion-io ioDrive PCIe card…: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first… shows individuals patterns and different handling of write and read IO cases. Follow @VadimTk !function(d,s,id){var js,fjs…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… with nobarrier. The results for random write case (8 async IO threads): In general it shows stable throughput topping to 148…, and it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB … this post I show the results of raw IO performance of this card. The benchmark methodology I described in previous posts, so… MiB/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… move on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC… are the join optimizations when the workload is IO bound. For the purpose of benchmarking IO bound workload, the InnoDB buffer pool size… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount… question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it… 20% better throughput. I am still going to run more benchmark to get better picture. The script for tests: for size…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you…
