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

Federico Razzoli

Database Specialist    |    MySQL Consultant

  • About Me
  • Testimonials
  • Services
  • Newsletter
  • Contacts

Month: May 2019

Indexes bad practices

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

When creating indexes, some common mistakes should be avoided.

Read more
InnoDB

Primary Key in InnoDB: how they work and best practices

Federico Razzoli May 21, 2019June 4, 2019 5 Comments

How primary key are implemented in InnoDB, and how to build fast primary keys.

Read more
InnoDB

MariaDB Stored Aggregate Functions by examples

Federico Razzoli May 9, 2019May 14, 2019 2 Comments

MariaDB 10.3 supports stored aggregate functions. Let’s see how to create them with examples.

Read more
MySQL for devs

3 good reasons to use Stored Procedures

Federico Razzoli May 7, 2019June 10, 2019 12 Comments

Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.

Read more
MySQL for devs

MySQL/MariaDB: run less queries! (thanks to performance_schema)

Federico Razzoli May 3, 2019October 7, 2019 Leave a comment

Do you want to improve your application’s and database server’s performance? Remove useless queries. Yes, you probably have them.

Read more
Query optimisation

Working with JSON objects in MySQL/MariaDB

Federico Razzoli May 1, 2019December 1, 2019 3 Comments

MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.

Read more
MySQL for devs

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.