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

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Month: October 2019

Foreign Key bugs in MySQL and MariaDB

Federico Razzoli October 16, 2019May 14, 2020 4 Comments

Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here.

Read more
InnoDB MySQL for devs

Case sensitivity in MySQL and MariaDB queries

Federico Razzoli October 2, 2019November 30, 2019 4 Comments

Maybe you’re wondering why in MySQL/MariaDB ‘string’ seems to be the same as ‘STRING’. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case …

Read more
MySQL for devs

Recent Articles

  • 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)
  • About Planet MySQL
  • MySQL danger: comments and ALTER TABLE

Categories

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

Recent Comments

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

Archives

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