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

Federico Razzoli

Database Specialist    |    MySQL Consultant

  • About Me
  • Testimonials
  • Services
  • Newsletter
  • Webinars
  • Contacts

Category: Operations

Dropping useless MySQL indexes

Federico Razzoli June 4, 2019April 1, 2020 6 Comments

How to find useless indexes and get rid of them to improve your database performance.

Read more
Operations

Setting performance and availability objectives (SLO)

Federico Razzoli April 17, 2019February 18, 2020 Leave a comment

How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.

Read more
Monitoring Operations

Dropping database objects in a safe way (→Vettabase)

Federico Razzoli April 12, 2019November 21, 2020 2 Comments

Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables …

Read more
Operations

The perils of ALTER TABLE in MySQL/MariaDB

Federico Razzoli April 3, 2019July 16, 2020 10 Comments

ALTER TABLE is often necessary, but it can be risky in a production environment for many reasons. Let’s discuss the problems that one has to take into account.

Read more
Operations
  • Next →

Learning Time

When do you learn job-related topics?
Vote

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
  • 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

  • Federico Razzoli on Practical advice for MySQL/MariaDB live migrations
  • Krzys on Practical advice for MySQL/MariaDB live migrations
  • Federico Razzoli on Practical advice for MySQL/MariaDB live migrations

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.