… periodic drops in performance which might be the result of the insert buffer filling up and then decreasing performance until some space is free’ed again. XtraDB lets you accelerate the rate at… seen big performance difference on insertion rate when increased insert buffer flushing was enabled (using the FB patch, not XtraDB but difference…
Post: Free ticket to MySQL User Conference on SF Meetup with talk "Percona XtraDB Cluster"
March 16, 2012 By Leave a Comment
… a reminder that I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March… User Conference 2012 and three copies our new book “High Performance MySQL, 3rd edition”. Well, I hope I will have printed…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from backup to give excellent performance without…. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… valid question, let me answer on it from different points. XtraDB Cluster is integration of Percona Server and Galera library. Both…: randgen (lp:randgen), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… 5.5.20 with group commit and xtradb. Even if they are faster. Galere performs awesome and you don’t have the…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… rest time we played with performance trying to align XtraDB performance with MySQL 5.4 ® and also port all performance fixes to 5.0…, table compression – XtraDB will support moving tables between servers – XtraDB will be released with fast recovery patch – XtraDB has additional performance fixes i.e…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… disk utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less 150MB/s in disk writes (from benchmarks we saw…. XtraDB is doing better job with internal contention, but much more can be done. Still you can have very impressive performance improvement in IO-intensive or IO-bound workloads. You may want to use InnoDB-plugin or XtraDB to get…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…: CPU scalability fixes – XtraDB improves performance on systems with multi-cpus (see docs 1, 2). Import/Export Tables – XtraDB allows you to import… is worse for performance. Â In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… busy to align XtraDB performance with 5.4, now we have some results. Currently it is available as “hacks” to XtraDB (available on…/percona-xtradb/hacks-porting-tune if you are interested). Basically we took improvements from 5.4 and backported ones performance related to XtraDB… you may say what’s the reason in XtraDB ? The most interesting reason is XtraDB based on InnoDB-plugin and contains its…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 18 Comments
… any point of time you can shutdown any Node to perform maintenance or make configuration changes. Or Node may crash or… of SST available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup with support of XtraDB Cluster will be released soon…. If it exceeds N, then the joining node has to perform SST. You can monitor current state of Node by using…
