June 18, 2013

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

… downloads area or from our software repositories. New Features: Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for…. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… RPM so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by this bug and will also… for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can…

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

…Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle…6” Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP …

Post: XtraDB in CPU-bound benchmark

… 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

… 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

… 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

… 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

… 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: Benchmarks challenges of XtraDB Cluster

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: PBXT in tpcc-like benchmark

… 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…