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.


MySQL backup methods comparison

MySQL backup methods comparison

MySQL backups can be made in several ways. Each method has pro's and con's. ...
Sizing Aria Pagecache

Sizing Aria Pagecache

Aria is a MariaDB storage engine that is always used internally. Its pagecache is the equivalent of InnoDB buffer pool, and this article is about sizing it properly. ...
Webinar: MySQL Backups

Webinar: MySQL Backups

It is important to understand which types of backups are available for MySQL and MariaDB databases, and to choose the best ones to use for a given use case. The webinar also gave hints to plan proper backup strategies, and to test them. ...
Can we shrink InnoDB Buffer Pool?

Can we shrink InnoDB Buffer Pool?

It's not easy to find out if InnoDB Buffer Pool is oversized. However shrinking it could greatly reduce the resources we need and pay, and even improve performance. ...
Is InnoDB Buffer Pool big enough? (→Vettabase)

Is InnoDB Buffer Pool big enough? (→Vettabase)

InnoDB buffer pool is the most important memory area to allocate to get decent performance. Let's see how to check if it's big enough. ...