… the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… it more complex than that? I’m new to Fusion-IO and I am going to do some testing with a…
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… the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench… 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
…: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first… gets even more interesting when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases… shows individuals patterns and different handling of write and read IO cases. Follow @VadimTk !function(d,s,id){var js,fjs…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… was lucky enough to get my hands on new Fusion-io ioDrive2 Duo card. So I decided to run the same… setup like this: I use a separate power supply. Fusion-io ioDrive2 Firmware v6.0.0, rev 107004 Public, Fusion… Duo. Now with separation per thread for random read synchronous IO: There is also excellent response time characteristics. 0.25ms and…
Post: Testing Fusion-io ioDrive - now with driver 3.1
May 7, 2012 By 2 Comments
… for everyone – if you are interested, please contact your Fusion-io support representative. I installed new drivers and firmware, and in… driver and firmware: Firmware v6.0.0, rev 107006. Fusion-io driver version: 3.1.1 build 172. Actually an upgrade… cases, there is 2x improvement. So it seems for Fusion-io ioDrive it is worth to consider upgrade to 3.1…
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… 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: 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… can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly underutilized. With the performance variance…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
I still continue to run benchmarks of different SSD cards. This time I show numbers for …. First, this time I use a different server. For this benchmark it is Cisco UCS C250, while for previous results I… so far in my benchmarks. To see distribution of response time, the results for random read synchronous IO. There we can see…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… usage for me), and recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB… –num-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0… with nobarrier. The results for random write case (8 async IO threads): It seems that InnoDB is not alone with its…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… both do not fully reflect my needs when I run benchmarks. Uniform is stupidly simple: for a table with 1 mln… to test cache, but it is hard to emulate high IO load. That’s why I was looking for alternatives, and… it sounds interesting. I am going to run couple incoming benchmarks with this distribution. Follow @VadimTk !function(d,s,id){var…
