]]> ]]>

Benchmarks For Percona Server

You are here

We frequently benchmark Percona Server. Benchmarks, when done scientifically, are a good way to help identify performance bottlenecks and validate the results of changes to software. We design ethical, apples-to-apples benchmarks that are as relevant as possible to real-world use cases.

MySQL 5.6.14 versus Percona Server 5.6.13

October 2013 Vadim Tkachenko benchmarked MySQL 5.6.14 against Percona Server 5.6.13 using a sysbench OLTP read-write workload with pareto distribution. The dataset used for the tests is 32 tables, 10mln rows each, which totals about ~77GB of data. Our interest is in testing intensive IO-bound workload, so the buffer_pool size is 25GB and we ran the load in 250 user threads.

  • Percona Server is significantly more stable than MySQL in maintaining high throughput after 4 minutes of load and beyond.
  • Percona Server delivers low latency and more consistency than MySQL after 4 minutes of load and beyond.

MySQL 5.5.8 versus Percona Server 5.5.7

December 2010 Vadim Tkachenko benchmarked MySQL 5.5.8, the newest high-performance release from Oracle, against Percona Server 5.5.7 beta in an OLTP workload similar to TPC-C. Key results:

  • Percona Server is more than 40% faster than MySQL in overall throughput.
  • Percona Server performance remains more stable over time than MySQL, which still experiences sharp drops in throughput due to checkpointing activity.

Benchmark Results

MySQL 5.5.4 versus Percona Server 5.1

April 2010 Vadim Tkachenko benchmarked MySQL 5.5.4, the newest high-performance release from Oracle, against Percona Server 5.1.54 in an OLTP workload similar to TPC-C. Key results:

  • Percona Server is more than 10% faster than MySQL in overall throughput.
  • Percona Server's performance is much more stable over time than MySQL's, which experiences sharp drops due to checkpointing activity when the data is larger than the buffer pool.
  • MySQL's performance is much better than previous releases.

Benchmark Results

MySQL 5.1.42 with InnoDB, InnoDB Plugin, and XtraDB on FusionIO

January 2010 Vadim Tkachenko benchmarked the standard InnoDB that ships with MySQL 5.1, the newer InnoDB Plugin, and XtraDB in a workload similar to TPC-C on fast FusionIO storage devices. Key results:

  • Standard InnoDB achieves 9.4k new-order transactions per minute, InnoDB plugin reaches 15.3k, and XtraDB reaches 26.1k. On this benchmark, XtraDB is up to 275% faster than InnoDB.
  • There is still heavy mutex contention, and much more improvement is possible even in XtraDB.

Benchmark Results

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK Toll Free)
0-800-181-0665 (GER Toll Free)
More Numbers
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>