MariaDB and MySQL storage engines: an overview
MySQL was the first DBMS to introduce the concept of storage engines in the early 2000s. This was one of its main features. Later, MariaDB extended the storage engine API and included some storage engine maintained by third parties as part of its official...
The UUID data type in MariaDB
MariaDB introduced the UUID data type in version 10.7. The first long-term support (LTS) version to include it is 10.11, which was declared stable in February 2023. In this article we will discuss how to use the UUID type, and why it is often wise to use it as a...
Overview of detailed slow query logging in MySQL 8: log_slow_extra
Every MySQL 8 minor release comes with a good number of bug fixes as well as exciting new features. MySQL 8.0.14 introduced the new log_slow_extra parameter. It is used to enable additional fields in the MySQL slow query log. They will help you get more information...
A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more
In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I’m a bit late because it was released last November, and versions 10.11 and 11.0 have been announced since then… All that is correct, but 10.10 is the latest...
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.