We are running internally a lot of benchmarks on our recently announced Percona XtraDB Cluster, and I am going to publish these… complain, but to make sure, if you are going to benchmark XtraDB Cluster yourself, there is a lot of things to take… this post is that if you are going to benchmark a Percona XtraDB Cluster or just use it under intensive communication workload…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication… XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera…
Post: XtraDB in CPU-bound benchmark
December 18, 2008 By Leave a Comment
… that previous results http://www.mysqlperformanceblog.com/2008/12/18/xtradb-benchmarks-15x-gain/ are too marketing, and we should show other…,or it would be more correctly to say in-cache benchmark, because there is a lot of CPU remains idle. This… has BBU installed. Other is simply properties of TPC-C benchmark which is rather lock intensive and may not be able…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… on new storage engine – show me benefits. So there is benchmark I made on one our servers. It is Dell 2950….2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I used scripts that emulate TPCC…_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with…: CPU (user) usage: Even with improvements, XtraDB performs less 150MB/s in disk writes (from benchmarks we saw FusionIO can do much…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… connection. For in-memory benchmark I set InnoDB buffer pool to 16GB, and for io-bound benchmarks I made it 3GB. Raw… some graphs here. In-memory benchmark, results during run: And averaged final result: As you see XtraDB, 5.0.83-percona and… this is topic for another benchmark. And now IO-bound results Again you can see that XtraDB, 5.0.83-percona and…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… of our customers gave me a chance to run some benchmarks on 24-core (intel cpu based) server, and I could… CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification… post. And last one workload I tried is TPCC-like benchmark (you can get it on https://launchpad.net/perconatools), with…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… config are on Wiki: http://www.percona.com/docs/wiki/benchmark:pbxt:tpcc:start there are graphs for 1 user: and… the maximal throughput in PBXT is about 1.5x better XtraDB, but there periodical drops which are very similar to periodical… better for PBXT: 5785.567 TpmC vs 4905.967 TpmC ( XtraDB) For 16 threads final result is: 26129.350 TpmC for…
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
… check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB… SAS 2.5″ 15K RPM disks). For comparison I took XtraDB-release5 and 5.0.77-highperf percona release. For raw… Spreadsheet (it is also being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph there: Results…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see… used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with next… from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small problem…
