…’t want to start a war but ZFS performance level was less than half of xfs for the tpcc test and that… last 2 hours and that will be perfectly fine. Since starting a snapshot take less than a second, you could even… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…’t really going to help me when I need to start writing massive amounts of data to disk. I could go… PCIe card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the…
Post: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
… 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….4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554 So when data…
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: on… able to attach previous cache, and MySQL was able to start and finish crash recovery. I am impressed. In my next…
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: Interesting…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… later Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt that it… of RAM and with FusionIO 320GB MLC card, and run tpcc-mysql benchmark with 500W using Percona Server 5.5.8… with –innodb-log-block-size=4096. Full benchmark command is tpcc_start localhost tpcc500 root “” 500 24 10 3600 From graph you…
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… 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 understanding…
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 22, 2010 By 25 Comments
… tpcc-mysql: there is no README either how to run it 
) I may suppose that I have to compile tpcc_load and tpcc_start…
Comment: MySQL 5.5.4 in tpcc-like workload
May 9, 2010 By 25 Comments
….4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554 So when data…
Comment: MySQL 5.5.4 in tpcc-like workload
April 23, 2010 By 25 Comments
… here: http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_variations we may find that io_capacity=1000…
