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

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Month: January 2020

Practical advice for MySQL/MariaDB live migrations

Federico Razzoli January 30, 2020February 11, 2020 12 Comments

Modifying table structures is sometimes necessary, or desirable. Modifying them online can be a pain, especially with big tables. Migrations should be ran properly in production.

Read more
Operations

PostgreSQL hstore: key/value in relational tables

Federico Razzoli January 28, 2020February 8, 2020 Leave a comment

hstore is a PostgreSQL extension that allows to store key/value pairs in relational tables and work with them.

Read more
PostgreSQL

Understanding tables usage with User Statistics (Percona Server, MariaDB) (→Vettabase)

Federico Razzoli January 6, 2020November 21, 2020 Leave a comment

Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.

Read more
Monitoring Operations

Recent Articles

  • DROP TABLE improvements in MariaDB (→Vettabase)
  • MariaDB RETURNING Statements (→Vettabase)
  • 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)

Categories

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

Recent Comments

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

Archives

  • July 2020 (2)
  • June 2020 (4)
  • May 2020 (3)
  • April 2020 (5)
  • 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.