I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting … 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…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
Thanks for posting the benchmarks. They are very informative. One question: when you configure MySQL, …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Justin, I would be doing another benchmark and use ‘innodb_ibuf_accel_rate’ together with tuning other IO related parameters that I can tune to good affect, and I will post my results.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…, so if you fail to actually index the data, the benchmark will notice.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
This benchmark doesn’t test the IO performance of EBS though as you’re not flushing to disks on each commit. What numbers do you get when you set innodb_flush_log_at_trx_commit to 1?
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… best read throughput I’ve seen so far in my benchmarks. To see distribution of response time, the results for random…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
Following my previous benchmark of Samsung 830, today I want to show results for … 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: 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… it sounds interesting. I am going to run couple incoming benchmarks with this distribution. Follow @VadimTk !function(d,s,id){var…
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 … the results of raw IO performance of this card. The benchmark methodology I described in previous posts, so let me jump…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… v5.0.7, rev 107053 Following the format of previous benchmarks, first is random write async 16KB case. We can see…
