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

Federico Razzoli

Database Specialist    |    MySQL Consultant

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

Month: April 2020

Is InnoDB Buffer Pool big enough? (→Vettabase)

Federico Razzoli April 28, 2020January 6, 2021 Leave a comment

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.

Read more
InnoDB

About Planet MySQL

Federico Razzoli April 24, 2020May 12, 2020 6 Comments

I’ve asked to remove Federico-Razzoli.com feed from Planet MySQL. Other well known members of the community did the same.

Read more
Community and news

MySQL danger: comments and ALTER TABLE

Federico Razzoli April 21, 2020April 21, 2020 2 Comments

In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.

Read more
Operations SQL

Logging all MySQL queries into the Slow Log (→Vettabase)

Federico Razzoli April 16, 2020November 13, 2020 Leave a comment

MySQL logs slow queries into the Slow Log. But it’s preferable to log all the queries, not just some of them. This article shows how to log all available information.

Read more
Operations

Two Weeks of Databases

Federico Razzoli April 14, 2020May 16, 2020 3 Comments

Two weeks of live interviews to relevant database persons, starting from 4th May.

Read more
Community and news

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