… performs in tpcc-like workload. The full details are on Wiki page http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start 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: 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 me… that PBXT team managed it. For initial runs I took tpcc 100 warehouses ( about 10GB of data) which fully fits into… PBXT spends more time in drops area. Again it looks like PBXT are not fully keeping up with checkpoint activity and…
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) on… 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: 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… our page with whitepapers, and in this post I would like to highlight the most interesting points. The chart with comparison… node. Clustrix is able to handle such complex workload as tpcc, and automatically distributes load between nodes despite multi-statements transactions…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… later Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt that it really… with –innodb-log-block-size=4096. Full benchmark command is tpcc_start localhost tpcc500 root “” 500 24 10 3600 From graph… block size. And I know that other SSD/Flash drives like to have IO multiplied to their internal block size (which…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… is available in PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge… details on hardware and software configuration are in full report tpcc-mysql tests were run for following combinations: 2400W, big buffer…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… days ago, Dimitri published a blog post, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a response to… C250 box with 346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB of data) on the… anyway. The full command line to run the test is: tpcc_start localhost tpcc500w root “” 500 32 10 1800. For better…
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 … for MySQL. The workload in tpce is quite different from tpcc. Tpcc is write intensive, while tpce is read oriented. To give…
