… size 6M MariaDB 5.5 (2) is for MariaDB 5.5 w/ buffer size 6M MariaDB 5.5 (3) is for MariaDB 5.5… appropriately for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you… buffers indirectly impact BKA performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5 or…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… when a MRR range scan is performed, but we can see its only incremented in MariaDB 5.5 and not in MySQL… mean that queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting… optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance of secondary key lookups as…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… contracts cover MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in… plugin. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5… different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… fact I would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than… from simply reading the blog posts on planet mysql) FWIW, MariaDB may very well be a good choice for Ubuntu and… non-security bugs like server crash, wrong result or just performance regressions. From my point of view the distros insisting on…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… with a perspective of how a piece of software will perform in the real world as much as possible, so they… that benchmark performance across the board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB which are…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… green line ist MariaDB 5.5.20 with group commit and xtradb. Even if they are faster. Galere performs awesome and you…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
Don’t forget that Timour and Sergei are giving a 3 hour tutorial on MariaDB 5.3 (and 5.5?) and MySQL 5.6 optimizers: http://www.percona.com/live/mysql-conference-2012/sessions/improving-mysqlmariadb-query-performance-through-optimizer-tuning
Post: MariaDB 5.3.4 benchmarks
February 18, 2012 By 22 Comments
… that MariaDB shows 20-30% worse throughput. It seems many changes resulted to performance hit in general. I wonder whether MariaDB team runs performance regression benchmarks, and if they do, why do we see such performance…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following… than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run different benchmarks… and performance. Update (6-Jun-2011): It was my misunderstanding: Galera does work with InnoDB-plugin also. You may try also MariaDB…
