Ask ChatGPT: MariaDB Performance Tuning: Tips and Tricks

This is the next in the series of posts exploring ChatGPT and its insights about MariaDB. The series began with ChatGPT, OpenAI and MariaDB Foundation, followed by Ask ChatGPT – Getting Started with MariaDB: A Comprehensive Guide for Beginners.

This week’s topic, suggested by ChatGPT itself, was “MariaDB Performance Tuning”. So how did it do?

MariaDB is undoubtedly one of the most popular open-source database management systems available today, with a strong focus on performance and ease of use. Whether you are a developer, database administrator, or an IT professional, ensuring that your MariaDB installation performs efficiently is crucial.

MariaDB 11.1.0 preview release now available

We are pleased to announce the availability of the MariaDB 11.1 preview release, MariaDB 11.1.0.

Candidate features for MariaDB 11.1

Preview releases are designed to get features into the hands of users more quickly, and should not be used for production. Features in a preview release may not all make the Generally Available (GA) release – only those that pass testing will be merged into MariaDB Server 11.1.1.

Features under consideration for 11.1 include:

Index usage with YEAR and DATE

With MDEV-8320, some queries using the DATE or the YEAR function will be much faster, as the optimizer is now able to make use of an index in certain cases.

MariaDB 10.10.3, 10.9.5, 10.8.7, 10.7.8, 10.6.12, 10.5.19, 10.4.28 and 10.3.38 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.10.3, MariaDB 10.9.5, MariaDB 10.8.7 and MariaDB 10.7.8, the latest Generally Available releases in their respective short-term series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.12, MariaDB 10.5.19, MariaDB 10.4.28 and MariaDB 10.3.38, the latest stable releases in their respective long-term series (maintained for five years).

See the release notes and changelogs for details.


Download MariaDB 10.10.3

Release Notes Changelog What is MariaDB 10.10?

MariaDB at FOSDEM 2023

MariaDB is at FOSDEM 2023, and it’s great to be back for the in-person event in Brussels for the first time since 2020. We’ll be participating in the MariaDB, MySQL and friends devroom. If you’re here in person, come see us live in room K.3.201 on Sunday morning, or come hang out at anytime our stand at Building K Level 1 Group B Stand 8.

And if you’re not enjoying the Belgian culinary delights and the rain in person, everything will be livestreamed, as well as available on video at a later stage. …

MariaDB 10.11.1 RC and 10.10.2 GA now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.1, the first release candidate in the MariaDB 10.11 series, and MariaDB 10.10.2 the first generally available release in the short-term MariaDB 10.10 series.

See the release notes and changelogs for details.


Download MariaDB 10.11.1

Release Notes Changelog What is MariaDB 10.11?


Download MariaDB 10.10.2

Release Notes Changelog What is MariaDB 10.10?


MariaDB APT and YUM Repository Configuration Generator


Contributors to MariaDB 10.11.1

Addison G
Aleksey Midenkov (MariaDB Corporation)
Alexander Barkov (MariaDB Corporation)
Alexey Botchkov (MariaDB Corporation)
Andrei Elkin (MariaDB Corporation)
Andrew Hutchings (MariaDB Foundation)
Anel Husakovic (MariaDB Foundation)
Angelique Sklavounos (MariaDB Corporation)
anson1014
Brad Smith
Brandon Nesterenko (MariaDB Corporation)
Daniel Bartholomew (MariaDB Corporation)
Daniel Black (MariaDB Foundation)
Daniele Sciascia (Codership)
Dmitry Shulga (MariaDB Corporation)
Elena Stepanova (MariaDB Corporation)
Haidong Ji (Amazon)
Hartmut Holzgraefe (MariaDB Corporation)
Ian Gilfillan (MariaDB Foundation)
Igor Babaev (MariaDB Corporation)
Jan Lindström (MariaDB Corporation)
Julius Goryavsky (MariaDB Corporation)
kurt
Lawrin Novitsky (MariaDB Corporation)
Lena Startseva (MariaDB Corporation)
Luis Eduardo Oliveira Lizardo
Marko Mäkelä (MariaDB Corporation)
Michael Qin (Amazon)
Michael Widenius (MariaDB Corporation and MariaDB Foundation)
Mikhail Chalov
Nayuta Yanagisawa
Nikita Malyavin (MariaDB Corporation)
NTH19
Oleg Smirnov
Oleksandr Byelkin (MariaDB Corporation)
Otto Kekäläinen
Paragoumba
qggcs
rmfalves
Rucha Deodhar (MariaDB Corporation)
sawasa
Sergei Golubchik (MariaDB Corporation)
Sergei Petrunia (MariaDB Corporation)
Thirunarayanan Balathandayuthapani (MariaDB Corporation)
tmokmss
Tuukka Pasanen
Vicențiu Ciorbaru (MariaDB Foundation)
Vladislav Vaintroub (MariaDB Corporation)
Vlad Lesin
Zhibo Zhang
50 Contributors

Contributors to MariaDB 10.10.2

Addison G
Aleksey Midenkov (MariaDB Corporation)
Alexander Barkov (MariaDB Corporation)
Alexey Botchkov (MariaDB Corporation)
Andrei Elkin (MariaDB Corporation)
Andrew Hutchings (MariaDB Foundation)
Anel Husakovic (MariaDB Foundation)
Angelique Sklavounos (MariaDB Corporation)
anson1014
Brad Smith
Brandon Nesterenko (MariaDB Corporation)
Daniel Bartholomew (MariaDB Corporation)
Daniel Black (MariaDB Foundation)
Daniele Sciascia (Codership)
Dmitry Shulga (MariaDB Corporation)
Elena Stepanova (MariaDB Corporation)
Haidong Ji (Amazon)
Ian Gilfillan (MariaDB Foundation)
Igor Babaev (MariaDB Corporation)
Jan Lindström (MariaDB Corporation)
Julius Goryavsky (MariaDB Corporation)
kurt
Lawrin Novitsky (MariaDB Corporation)
Lena Startseva (MariaDB Corporation)
Marko Mäkelä (MariaDB Corporation)
Michael Widenius (MariaDB Corporation and MariaDB Foundation)
Mikhail Chalov
Nayuta Yanagisawa
Nikita Malyavin (MariaDB Corporation)
Oleg Smirnov
Oleksandr Byelkin (MariaDB Corporation)
Otto Kekäläinen
qggcs
Rucha Deodhar (MariaDB Corporation)
Sergei Golubchik (MariaDB Corporation)
Sergei Petrunia (MariaDB Corporation)
Thirunarayanan Balathandayuthapani (MariaDB Corporation)
tmokmss
Tuukka Pasanen
Vicențiu Ciorbaru (MariaDB Foundation)
Vladislav Vaintroub (MariaDB Corporation)
Vlad Lesin
Zhibo Zhang
43 Contributors

Thanks, and enjoy MariaDB! …

CfP for the MariaDB, MySQL and Friends devroom FOSDEM 2023 now open

FOSDEM 2023 is happily once again going to be an in-person event, and MariaDB will be participating as part of the MariaDB, MySQL and Friends devroom. The Call for Papers is now open.

FOSDEM 2023 will take place on Sat 4 to Sun 5 February 2023 at the ULB Solbosch Campus, Brussels, Belgium.

There are some changes in the organization to previous years. MySQL and MariaDB will each be responsible for its own track, so we will divide the devroom in two sub-tracks.

For the convenience of the speakers and participants, we will not mix the two sub-tracks, and you will have the possibility to follow either track you are interested in, or of course both. …

MariaDB 10.9.4, 10.8.6, 10.7.7, 10.6.11, 10.5.18, 10.4.27 and 10.3.37 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.4, MariaDB 10.8.6 and MariaDB 10.7.7, the latest Generally Available releases in their respective short-term series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.11, MariaDB 10.5.18, MariaDB 10.4.27 and MariaDB 10.3.37, the latest stable release in their respective long-term series (maintained for five years).

See the release notes and changelogs for details.


Download MariaDB 10.9.4

Release Notes Changelog What is MariaDB 10.9?

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.