… 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…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… and multi-disks utilization. Also results may be different if load is CPU bound. I compared MySQL 5.1.30 trees… compiled in MySQL) For benchmarks I used scripts that emulate TPCC load and datasize 40W (about 4GB in size), 20 client connections… and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb_buffer…
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 22, 2010 By 25 Comments
… the tpcc-mysql: there is no README either how to run it 
) I may suppose that I have to compile tpcc_load and tpcc_start, then load the data, and then run a test… May… 3 lines: – how I create db schema – how do I load the data (exactly params) – how do I run the test…
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… compared with Percona Server/XtraDB, so there is the same load on our server: As you see our adaptive_checkpoint algorithm….4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554 So when…
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… is able to handle such complex workload as tpcc, and automatically distributes load between nodes despite multi-statements transactions and foreign key…
Post: FlashCache: tpcc workload with FusionIO card as cache
June 2, 2010 By 20 Comments
… if you want extra warranty for data consistency and your load is mostly read-bound, so I tested this mode also…). Write-through mode is about 2x gain, but remember that load is very write intensive and all benefits in write-through…
Post: 5.4 in-memory tpcc-like load
May 1, 2009 By 11 Comments
…-io-bound-benchmarks/ on 5.4 I tried in-memory load (basically changed buffer pool from 3GB to 15GB, and database…
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… session, affect a response time of queries that handle user load ? The same for mysqldump, how does it affect short user…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 Comments
…-dev/percona-xtradb/extensions-1.0.6 I made small tpcc benchmark to show effect with restored buffer_pool (the condition… ( it took about 4 min to load 26GB worth of data), and run (xtradb warm) tpcc again. Here is graphical results (results… unstable results, but it did not affect ability to serve load. You are welcome to test it, it is available in…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… take look what a lifetime we can expect under a tpcc-mysql workload. I put 32 users threads against 5000W dataset… more space. Please note we put a quite intensive write load during this hour. MySQL handled 25,000 updates/sec, 20…. However, in real production you do not have an uniform load every hour, so you may base your estimation on daily…
