… that MySQL 5.5 beats both BKA of MySQL 5.6 and Hash Join of MariaDB 5.5. In IO bound test MySQL 5… test, MySQL 5.5 takes 5x less time as compared to MySQL 5.6 and 13x less time as compared to MariaDB 5… support the possibility of existence of different join algorithms. So what does that mean to MariaDB/MySQL users right now with the state…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6 and MariaDB… not used, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly…
Post: Using MySQL Sandbox with Percona Server
February 16, 2013 By 3 Comments
… with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… Suite solution for deploying and managing MySQL in the Cloud. MariaDB have showcased MariaDB 5.5 and forthcoming MariaDB 10 Alpha release. The Cassandra storage engine is the level of integration between MySQL and… call it pretty proven used with MySQL. Nimbus Data also handles Flash storage but at different scale. If you prefer SAN/NAS…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… Benchmarking MariaDB-5.3.4 The initial benchmark is described in Benchmarks of Intel 320 SSD 600GB, and the result for MySQL… average will be different: MySQL: 3746 tps Percona Server: 3704 tps And for comparison, average throughput for 4 tables: MySQL: 3882 tps Percona… can fall back to the vanilla InnoDB-plugin, like MariaDB suggests in Benchmarking MariaDB-5.3.4. Raw results and scripts are…
Post: New MariaDB release is out
October 30, 2009 By Leave a Comment
MariaDB project kept development going in the repository only not providing any binary releases since April, so release was well over due and it is here now. If you’re wondering how this release of MariaDB is different from MySQL you should read this FAQ
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…. However, PBXT’s log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT… InnoDB in REPEATABLE READ mode, then there is essentially no difference in the isolation paradigm between the two engines. REPEATABLE READ… modifying any part of MySQL to make the engine work. This means that PBXT runs with the standard MySQL/MariaDB distribution. But this…
Comment: When does Innodb Start Transaction ?
January 12, 2011 By 9 Comments
… different things. You understand that it’s impossible to do that will meet everybody’s expectations. So, when different people expect MySQL do different things in the same situation, we needed (and need – but in MariaDB 
an arbitrator, an…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… which we many times wrote about. The fix came into MariaDB 5.3 and Mark Callaghan tested it recently . We ported… 256 57.62 1669.11 As you may see, the difference is pretty obvious. I also ran a second test to… 2877.98 2145.32 2188.38 There is still performance difference binlogs vs no-binlogs, but it is much smaller when…
