Thoughts on MariaDB Server 10.3 from MariaDB Developers Meeting in Amsterdam, part 1

I had the honor of leading a session on Saturday, during the MariaDB Developers Meeting in Amsterdam, brainstorming around MariaDB Server 10.3. It’s definitely time to do that since MariaDB Server 10.2 has entered beta stage. In case you have missed that, I’ve wrapped up what’s included in 10.2 so far in a blog post on my employer’s site. In addition to the features mentioned in that blog post there are a couple of features still coming in 10.2 of which the most notable is that the MyRocks engine will be included. More about this later in another article. Read more

MariaDB 10.1 and MySQL 5.7 performance on commodity hardware

When you have read my previous blog post about MariaDB 10.1 GA performance, you have probably wondered why I didn’t include any numbers for MySQL 5.7. There are two reasons: first MySQL wasn’t GA at that time and secondly MySQL is not running stable on Power8.

Today I will come up with a comparison benchmark. I have chosen some more down-to-earth hardware for that because that is what the majority of our users will be running. Specifically it’s a SP-64 cloud machine from OVH. It has a 4-core Intel CPU and 64G of RAM. Disks aren’t fancy, but the benchmark is again a simplified read-only OLTP workload that runs from memory. Read more

Performance evaluation of MariaDB 10.1 and MySQL 5.7.4-labs-tplc

Introduction

Evaluating the performance of database systems is a very demanding task. There are a lot of hard choices to be made, e.g.:

  • What operating system and operating system version is to be used
  • What configuration setup is to be used
  • What benchmarks are to be used and how long are the warm-up and measure times
  • What test setups are to be used
  • What version of the database management system is used
  • What storage engine is used

While performance evaluation is mostly machine time, there is still a lot of hard work for the human monitoring the tests. Read more