… valid question, let me answer on it from different points. XtraDB Cluster is integration of Percona Server and Galera library. Both… integration and packaging. Galera was in in my focus since 2009, so this is really 3 years of testing and evaluations…
Post: XtraDB Amazon Image
October 25, 2009 By 9 Comments
… who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use… default INSTANCE i-ecc74084 ami-4701e22e pending 0 m1.large 2009-10-25T18:31:06+0000 us-east-1c Wait till…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… I followed Yoshinori Matsunobu’s recommendations http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd-redobinlogsystem.html and taking fact that… summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of FusionIO. XtraDB is doing better job with internal…
Post: Announcing Percona Performance Conference 2009 on April 22 & 23
February 5, 2009 By 5 Comments
… Percona warmly invite you to Percona Performance Conference 2009 on April 22 and 23, 2009 in the Hyatt Regency in Santa Clara… sessions from Percona this year on the schedule for the 2009 MySQL Conference and Expo. This is not because we didn… among the world’s foremost experts on MySQL, InnoDB, and XtraDB, and it’s true that the database is usually harder…
Post: InnoDB/XtraDB Training in New York City!
September 25, 2009 By 2 Comments
… training location will be New York City on October 30, 2009. We’ve booked a training venue in the financial district…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… username) FROM tracker where TIME_ID >= ‘2009-07-20 00:00:00′ AND TIME_ID = ‘2009-07-20 00:00:00′ AND… you cannot really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with… statistics in 5.0-percona releases (coming to 5.1-XtraDB soon)
Comment: MySQL 5.5-m2 scalability
March 1, 2010 By 17 Comments
… yourself: http://www.mysqlperformanceblog.com/2009/07/14/performance-improvements-in-percona-5-0-83-and-xtradb/ You specifically made changes to… to see performance against the Percona performance build and against Xtradb. In fact, it would be nice to see a blog post on how the Percona performance build is different from Xtradb, and if there’s a version # at which they’re…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000…”: Normal InnoDB Plugin 1.0.4 without XtraDB specific options “xtra p_t 0″: XtraDB 1.0.4-new (no purge_thread…_STRESS benchmark is obtained by these tunings of XtraDB. —————————————– (Added 2009.10.29)
Comment: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… are between the built-in InnoDB and XtraDB. In general both the plugin and XtraDB are in a class of their own… blog: http://dimitrik.free.fr/blog/archives/08-01-2009_08-31-2009.html Do note when reading benchmarks that a lot…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB… the case. For example a test (http://mysqlha.blogspot.com/2009/03/pbxt-is-fast-no-kidding.html) by Mark Callaghan… Heiki for InnoDB, and the latter, an excellent addition to XtraDB). Both methods improve the management of the asynchronous writes. The…
