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

Federico Razzoli

Database Specialist    |    MySQL Consultant

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

Category: MySQL and MariaDB

DROP TABLE improvements in MariaDB (→Vettabase)

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

MariaDB made several improvements to the DROP TABLE statement.

Read more
Operations Uncategorized

MariaDB RETURNING Statements (→Vettabase)

Federico Razzoli July 7, 2020November 13, 2020 Leave a comment

MariaDB supports INSERT RETURNING and DELETE RETURNING, which help avoid an additional SELECT.

Read more
MySQL and MariaDB SQL

MySQL backup methods comparison

Federico Razzoli June 1, 2020June 1, 2020 1 Comment

MySQL backups can be made in several ways. Each method has pro’s and con’s.

Read more
Operations

Sizing Aria Pagecache

Federico Razzoli May 29, 2020May 31, 2020 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

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

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

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

Use cases for MariaDB Invisible Columns

Federico Razzoli February 11, 2020February 12, 2020 Leave a comment

Invisible columns are columns that are not returned by a SELECT *. Their use cases are not obvious.

Read more
Operations

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

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.