Database Performance

The database performance category is the place to dive into the depths of weird and interesting database behavior.

Where Does MySQL Get Its Host?

Where does MySQL get its host? This question is asked by many novices and experienced MySQL DBAs alike. Dig into…

2 weeks ago

Don’t Perform a MySQL Update After MySQL 8.0.37!

If you run thousands of tables, don't perform any MySQL update beyond MySQL 8.0.37, at least for now. Read this…

2 weeks ago

What is ClickHouse and How Does It Work? ClickHouse Database Explained

In this blog, we answer questions related to ClickHouse and tell you what the ClickHouse database is and how ClickHouse…

2 months ago

PostgreSQL vs MySQL: A Comparison

In this PostgreSQL vs MySQL blog, we walk you through when to choose PostgreSQL or MySQL for your use case.

2 months ago

Composite Indexes in Databases: What are They?

In this blog, we tell you it all about composite indexes - what they are, how they work, and when…

2 years ago

MyISAM vs. InnoDB: The Problem

In this blog post, we tell you how does MyISAM compare with InnoDB.

2 years ago

Choosing Character Sets in MySQL: A Short Guide

In this blog, we will look a little closer into the character sets available in MySQL – we will tell…

2 years ago

The MySQL Server – mysqld

In this blog, we discuss the ins and outs of the MySQL daemon and tell you how best to improve…

2 years ago

MySQL Security Best Practices: A Checklist

MySQL Security Best Practices: A Checklist In an ever-changing technology landscape, it is critical for companies and individuals to know…

2 years ago

Schrödinger’s Paradox in MySQL

If you have ever dived deeper into physics and quantum mechanics in particular, you have probably heard of this weird…

4 years ago