…), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
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 Duo…://www.percona.com/files/white-papers/virident-mlc-tpcc.pdf The graphical result for tpcc-mysql 5000W: My conclusions from this benchmark: Virident…, in many cases there is also a better throughput in MySQL (up to 40\%) using the Virident FlashMAX card. DISCLOSURE: This…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… is 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: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
… 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… 2000 for MySQL 5.5.4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… 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 FlashCache… after restart FlashCache was able to attach previous cache, and MySQL was able to start and finish crash recovery. I am…
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. I… on row level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users. Also…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… available in PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage… configuration are in full report tpcc-mysql tests were run for following combinations: 2400W, big buffer pool 1 MySQL instance, 2400 warehouses (220GB…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… post, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and… C250 box with 346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB of data) on the FusionIO… NOTPM. The throughput is about 1.33x better than in “MySQL compatible mode”, though it requires 10500MB for checkpoint age; that…
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 … TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. You… compare with available Storage Engines for MySQL. The workload in tpce is quite different from tpcc. Tpcc is write intensive, while tpce is…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… a FusionIO 320GB MLC card. First, the results for tpcc-mysql, 500w (around 50GB of data) on RAID10. I used innodb…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server… query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred Linhoss)
