… that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5… Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5… 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5.6…
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…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
Baron: On MariaDB vs Percona server, I sometimes see MariaDB having a group consisting of rather ignorant users. This is not supposed to say anything negative of MariaDB or its developers, or even the entire userbase as a… of this ignorant group is something like: * MariaDB is the new MySQL * Oracle’s MySQL is completely closed source or at least will…
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… sec, to exclude warmup period, the average will be different: MySQL: 3746 tps Percona Server: 3704 tps And for comparison, average… can fall back to the vanilla InnoDB-plugin, like MariaDB suggests in Benchmarking MariaDB-5.3.4. Raw results and scripts are…
Comment: MariaDB 5.3.4 benchmarks
February 18, 2012 By 22 Comments
…. Now about fairness: MariaDB 5.3 is RC for the next production ready MariaDB‘s flagship database. For MySQL the current pre-production product is 5.6. So there we compare the future MariaDB with the current MySQL 5.5, and probably more fair would be to compare MariaDB 5.3 vs MySQL 5.6.
Comment: MariaDB 5.3.4 benchmarks
February 20, 2012 By 22 Comments
I agree with comparison of MariaDB 5.3 vs MySQL 5.5. Comparing it to MySQL 5.1 is really useless (at last to me). I hope MariaDB 5.5 get ready before MySQL 5.6.
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
> [..] MariaDB with the current MySQL 5.5, and probably more fair would be to compare MariaDB 5.3 vs MySQL 5.6. If your goal was to compare prerelease products, sure, but that wasn’t the goal that you established in the first paragraph — “check how all improvements affect general performance”.
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… 2145.32 2188.38 There is still performance difference binlogs vs no-binlogs, but it is much smaller when you have…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… percentage of time the replication thread was busy replicating events vs staying idle. Note you can speak about idle replication capacity… Server and MariaDB. This is the probably the easiest and most accurate approach but it does not work in Oracle MySQL Server… and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS…
