…XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
….30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I…_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint = 1 innodb_write_io_threads = 16 innodb…
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… benchmark, because there is a lot of CPU remains idle. This run is exactly the same as Disk Bound but with innodb… you can see they are very different for XtraDB and Innodb storage engines. Innodb has generally higher CPU usage and more uniform while…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates intensive…. Fortunately InnoDB internally has mechanism to support multiple rollback segments – and Yasufumi just made patch to enable it. I rerun benchmarks on… 10 on 8 disks) to compare mysql-5.1.30-XtraDB-1.0.2-pre-release3 with default (1) and 16…
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
… InnoDB/XtraDB code we invite you to join our development team to work on the following (but not limited to) problems: Fix InnoDB…) Make InnoDB just in general faster on SSD, so we do need to create several instances, like in my recent benchmarks Add more features for Percona XtraBackup And work on our new area of interest: clustering solution based on XtraDB + Galera…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… MySQL / InnoDB performs 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…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification… MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been… grows up to 16 connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… 16 connection. For in-memory benchmark I set InnoDB buffer pool to 16GB, and for io-bound benchmarks I made it 3GB. Raw… CREATION, table compression – XtraDB will support moving tables between servers – XtraDB will be released with fast recovery patch – XtraDB has additional performance fixes…
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… about 1.5x better XtraDB, but there periodical drops which are very similar to periodical drops in InnoDB without adaptive checkpointing, and… better for PBXT: 5785.567 TpmC vs 4905.967 TpmC ( XtraDB) For 16 threads final result is: 26129.350 TpmC for…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
…xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file … And sysbench uses 16KB pagesize to emulate work of InnoDB with 16KB pagesize. Raw results you may find …-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be …
