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

Federico Razzoli

Database Specialist    |    MySQL Consultant

  • About Me
  • Testimonials
  • Services
  • Newsletter
  • Contacts

Tag: index

Case sensitivity in MySQL and MariaDB queries

Federico Razzoli October 2, 2019November 30, 2019 2 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

Dropping useless MySQL indexes

Federico Razzoli June 4, 2019October 2, 2019 6 Comments

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

Read more
Operations

Indexes bad practices

Federico Razzoli May 31, 2019December 8, 2019 5 Comments

When creating indexes, some common mistakes should be avoided.

Read more
InnoDB

Dropping database objects in a safe way

Federico Razzoli April 12, 2019December 8, 2019 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

MySQL: IS NULL conditions and indexes

Federico Razzoli March 8, 2019October 2, 2019 2 Comments

It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow.

Read more
Query optimisation

Recent Articles

  • The dangers of replication filters in MySQL
  • Foreign Key bugs in MySQL and MariaDB
  • Case sensitivity in MySQL and MariaDB queries
  • Optimising or fixing SQL queries: how to ask for help
  • London Meetup – Open Source Communities: vendors and users working together (September 2019)
  • Choosing Cassandra consistency levels
  • READ ONLY transactions in MySQL
  • Cassandra error on login: Cannot achieve consistency level LOCAL_ONE
  • Why MySQL tables need a primary key
  • MySQL/MariaDB: use SQL properly to run less queries

Categories

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

Recent Comments

  • Federico Razzoli on The dangers of replication filters in MySQL
  • Georgi D. Sotirov on The dangers of replication filters in MySQL
  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB

Archives

  • 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 © 2019 Federico Razzoli.
Powered by WordPress. | Theme: colorskin by Dimitrakopoulos.