… is placed on Intel SSD card. This time I am using tpcc-like workload with 1000 Warehouses ( that gives 100GB of data… fit into cache partition). Please note in this configuration the benchmark is very write intensive, and it is not going be… report and results are available on benchmark Wiki http://www.percona.com/docs/wiki/benchmark:flashcache:tpcc:start. Short version of results are…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
… I am trying to present some data from my benchmarks. For tests I use tpcc-mysql, datasize 600W (~60GB) with buffer pool 52GB… – result just on single node, without any replication. This is used to establish baseline wsrep – result on single node with enabled…, but not only on single. Scripts and raw results on Benchmarks Launchpad (function() { var po = document.createElement(‘script’); po.type = ‘text…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the… existing benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql…
Post: Virident FlashMAX MLC in tpcc-mysql workload
November 29, 2011 By 7 Comments
…/files/white-papers/virident-mlc-tpcc.pdf The graphical result for tpcc-mysql 5000W: My conclusions from this benchmark: Virident FlashMAX provides stability… better throughput in MySQL (up to 40\%) using the Virident FlashMAX card. DISCLOSURE: This benchmark was done as part of our consulting…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… and tpcc-mysql benchmarks. I will present the results for sysbench oltp (with full report available later) below, and the results for tpcc… one to adequately fill both cards in comparison. Some hardware used in benchmarks include: Server: Cisco UCS C250, running Oracle Linux 6…_log_at_trx_commit=1 As in all my recent benchmarks, I use long runs of 1 hour each with measurements every…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… performance characteristics of Clustrix under tpcc-mysql workload. I tested tpcc 5000W (~500GB of data in InnoDB…this server is equal to hardware that Clustrix uses for its nodes). The full report is … more is better) So my conclusions from this benchmark: Clustrix shows very good scalability in the …
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 3 Comments
We have been using tpcc-mysql benchmark for long time, and there many results published in our … single workload. That’s why we are looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts… human words is: You can’t name results as “TPC Benchmark Results” You can’t compare results with results published on…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read… explains why READ COMMITED is better for TPCC load, so why don’t we take tpcc-mysql bencmark and check on results… of contention on row level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… moment.) For this post, I made tpcc-runs on our Dell PowerEdge R900 box, using RAID10 over 8 disks and a FusionIO… MySQL 5.5.8. It is 500 ( which I used in benchmarks above), 4000 and 20000. As you see there is no… getting worse results. For reference, here is the config file used for benchmarks on FusionIO: [client] socket=/var/lib/mysql/mysql.sock…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… report is available in PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell… details on hardware and software configuration are in full report tpcc-mysql tests were run for following combinations: 2400W, big buffer… MySQL. I am looking forward to test it. Disclaimer: This benchmark is sponsored by Fusion-io, but this post is totally…
