…), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
Post: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
… with performance improvements, let’s see how it performs in tpcc-like workload. The full details are on Wiki page http… I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data), InnoDB….4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554 So when…
Post: Virident FlashMAX MLC in tpcc-mysql workload
November 29, 2011 By 7 Comments
… on Virident FlashMAX MLC, beside sysbench benchmark, I also run tpcc-mysql (to compare performance Virident FlashMAX vs Fusion-io ioDrive…://www.percona.com/files/white-papers/virident-mlc-tpcc.pdf The graphical result for tpcc-mysql 5000W: My conclusions from this benchmark…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… the report on performance characteristics of Clustrix under tpcc-mysql workload. I tested tpcc 5000W (~500GB of data in InnoDB) on Clustrix… node. Clustrix is able to handle such complex workload as tpcc, and automatically distributes load between nodes despite multi-statements transactions…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was bug with did not allow… that PBXT team managed it. For initial runs I took tpcc 100 warehouses ( about 10GB of data) which fully fits into… on Wiki: http://www.percona.com/docs/wiki/benchmark:pbxt:tpcc:start there are graphs for 1 user: and 16 users…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… placed on Intel SSD card. This time I am using tpcc-like workload with 1000 Warehouses ( that gives 100GB of data… benchmark Wiki http://www.percona.com/docs/wiki/benchmark:flashcache:tpcc:start. Short version of results are on graph: In summary… turned off power on SSD drive in the middle of tpcc-mysql run, just SSD power, not whole server. No wonder…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… explains why READ COMMITED is better for TPCC load, so why don’t we take tpcc-mysql bencmark and check on results… on row level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… cfq to noop solved their InnoDB IO problems. I ran tpcc scripts against XtraDB on our Dell PowerEdge R900 server (16… / deadline can utilize disks much better. For reference I used tpcc scripts from https://launchpad.net/perconatools, generated 100W (about 9…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… skipped. Copying ./tpcc/stock.ibd is skipped. Copying ./tpcc/warehouse.ibd is skipped. Copying ./tpcc/new_orders.ibd is skipped. Copying ./tpcc/order_line… ./tpcc/district.ibd is skipped. Copying ./tpcc/orders.ibd is skipped. Copying ./tpcc/item.ibd is skipped. Copying ./tpcc/customer.ibd is skipped. Copying ./tpcc…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time… not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try to push the database…
