This one trick can make MariaDB 30x faster!

Yes, it is a bit of a click-bait title, but in this case running one SQL command did improve a community user’s performance by that much. It could help you too.

The story

A community user posted in a couple of places that when migrating a large WordPress installation to MariaDB that they were seeing a certain query performing terribly. The query was taking 1.5 seconds to execute and it was clear from the explain plan that the optimizer was not making an ideal decision about the join order.

The query was generated by WordPress so it would not be easy to force an index, or rewrite the query.

Contribution Statistics September 2022

Last month we provided contributor statistics for the last few years. We have had some fantastic feedback from this so today we are presenting you with another drop of contributor statistics for the last month. Normally we would be doing these quarterly but there are so many extra things to report that we decided to do a bonus one now.

Some key things have happened in the last month which affect the data, the first is that MariaDB 10.11 has had a preview release. Which means there has been a flurry of activity around this.

MariaDB Server Fest 17 Nov 2022

The MariaDB Foundation will be hosting a Server Fest on Thursday 17 November 2022. This time it’ll be a hybrid event, harnessing the energy that comes from many of the participants being present in person.

To encourage interaction, the event will be streamed live, but will not immediately be made available online, so don’t miss out on this opportunity to interact with the speakers and MariaDB members in person!

The keynote speaker will be Wikimedia Foundation’s Manuel Arostegui. The schedule and further details will be announced soon.

We start at 14:00 Paris time (CET) – 8:00am New York, 20:00 Beijing.

Regressions in recent MariaDB Server releases

Our most recent MariaDB Server release introduced some regressions starting with the 10.6 series, affecting 10.7 – 10.9 as well. This blog post is here to explain the problems in hopes that the impact is minimized. We are likely going to release a new version of MariaDB correcting these problems soon.

InnoDB Full Text Index on tables causes an assertion error (MDEV-29342)

There was a bug in the InnoDB Storage Engine where the full text index could go out of sync with the actual table data. This would happen when only one new row was inserted between the last InnoDB sync (which happens asynchronously) and a server shutdown.

Generating MariaDB Metrics

Something that is very important to us in the MariaDB Foundation is “Openness”. This is not only in the open source nature of MariaDB, but we are also very transparent in what happens with the MariaDB source code. With that in mind we have been working on ways to generate metrics that show information about the community in a consumable form.

(more…)

The Path to Code Contributions in MariaDB Server

I have been working for the MariaDB Foundation as the Chief Contributions Officer for a couple of weeks and it is fantastic being part of the MariaDB family again. Part of my job is to help the community massage pull requests into something that we can merge. I am, however, finding that one of the worst parts of my job is having to say “no” to contributions that clearly took a lot of time and effort on the part of the developer.

Contributions could be turned down or at least will require changes for a number of reasons.

Contribution Wish List

Would you like to contribute to the MariaDB Server code base, its feature set, its quality? Here’s what you can do to help – in other words, here’s our Contribution Wish List

Scratching your own itch

The assumption around code contributions is usually that the code contributor extends the product in a direction that corresponds to the contributor’s own needs, which in turn are close to the needs of other users. “Scratching your own itch” is the phrase commonly used.

Some itches are more for the common good

That said, we have also been approached by potential providers of contributions that would take a more general approach.