When creating indexes, some common mistakes should be avoided.
Read morePrimary Key in InnoDB: how they work and best practices
How primary key are implemented in InnoDB, and how to build fast primary keys.
Read moreMariaDB Stored Aggregate Functions by examples
Let’s use MariaDB 10.3 stored aggregate functions to implement a geometric mean.
Read more3 good reasons to use Stored Procedures
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.
Read moreMySQL/MariaDB: run less queries! (thanks to performance_schema)
Do you want to improve your application’s and database server’s performance? Remove useless queries. Yes, you probably have them.
Read moreWorking with JSON objects in MySQL/MariaDB
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.
Read more