When creating indexes, some common mistakes should be avoided.
How primary key are implemented in InnoDB, and how to build fast primary keys.
MariaDB 10.3 supports stored aggregate functions. Let’s see how to create them with examples.
Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.
Do you want to improve your application’s and database server’s performance? Remove useless queries. Yes, you probably have them.
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.
TEXT and BLOB are special types in MySQL/MariaDB. This article helps to understand them and use them properly.
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables …
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.