Welcome to Federico-Razzoli.com

Most of Federico-Razzoli.com articles
are slowly being moved to Vettabase.com,
and in particular Vettabase blog.

This website will eventually contain my personal views and personal projects.
New contents will not necessarily be technical.


Dropping useless MySQL indexes (→Vettabase)

Dropping useless MySQL indexes (→Vettabase)

How to find useless indexes and get rid of them to improve your database performance. ...
InnoDB Indexes Bad Practices

InnoDB Indexes Bad Practices

When creating indexes, some common mistakes should be avoided. ...
Primary Key in InnoDB: how they work and best practices

Primary Key in InnoDB: how they work and best practices

How primary key are implemented in InnoDB, and how to build fast primary keys. ...
MariaDB Stored Aggregate Functions by examples

MariaDB Stored Aggregate Functions by examples

Let's use MariaDB 10.3 stored aggregate functions to implement a geometric mean. ...
3 good reasons to use Stored Procedures

3 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. ...