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

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Category: Operations

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

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 (→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

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

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

MySQL/MariaDB: Using views to grant or deny row-level privileges (→Vettabase)

Federico Razzoli December 16, 2019November 17, 2020 Leave a comment

Relational DBMSs allow to grant users permissions on certain tables or columns. Here we’ll discuss how to restrict access to a certain set of rows.

Read more
Operations

The dangers of replication filters in MySQL

Federico Razzoli November 29, 2019April 1, 2020 2 Comments

MySQL supports replication filters and binlog filters. These features are powerful, but dangerous. Here you’ll find out the risks, and how to mitigate them.

Read more
Operations
  • ← Previous

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.