Skip to content
  • +44 7739 427279
  • info@federico-razzoli.com

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Month: May 2020

Sizing Aria Pagecache (→Vettabase)

Federico Razzoli May 29, 2020February 19, 2021 2 Comments

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.

Read more
Operations

Webinar: MySQL Backups

Federico Razzoli May 19, 2020June 11, 2020 2 Comments

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.

Read more
Community and news

Can we shrink InnoDB Buffer Pool? (→Vettabase)

Federico Razzoli May 16, 2020January 21, 2021 5 Comments

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.

Read more
InnoDB

Recent Articles

  • Do languages need NULL? – Rust example
  • Webinar: Database Design most common pitfalls
  • Consistency Level patterns for high accuracy in Cassandra
  • MySQL backup methods comparison
  • Sizing Aria Pagecache (→Vettabase)
  • Webinar: MySQL Backups
  • Can we shrink InnoDB Buffer Pool? (→Vettabase)
  • Is InnoDB Buffer Pool big enough? (→Vettabase)
  • About Planet MySQL
  • MySQL danger: comments and ALTER TABLE

Categories

  • Amazon Redshift
  • Cassandra
  • Community and news
  • InnoDB
  • Monitoring
  • MySQL and MariaDB
  • MySQL for devs
  • Operations
  • PostgreSQL
  • Query optimisation
  • SQL
  • Stored procedures

Recent Comments

  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB
  • Daniel R. on Working with JSON arrays in MySQL/MariaDB
  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB

Archives

  • June 2020 (4)
  • May 2020 (3)
  • April 2020 (4)
  • March 2020 (3)
  • February 2020 (2)
  • January 2020 (3)
  • December 2019 (2)
  • November 2019 (1)
  • October 2019 (2)
  • September 2019 (3)
  • August 2019 (3)
  • July 2019 (1)
  • June 2019 (5)
  • May 2019 (6)
  • April 2019 (7)
  • March 2019 (4)
  • February 2019 (6)
Copyright © 2021 Federico Razzoli.
Powered by WordPress. | Theme: colorskin by Dimitrakopoulos.