Databases

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…

3 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

MySQL After a Data Breach

As we all know, data breaches occur all too often. After a data breach occurs, we are used to seeing…

4 years ago

InnoDB From the Inside: ibdata1 and the Log Files

The ibdata1 file is arguably the most important file in the entire InnoDB infrastructure. Without the file InnoDB simply could…

5 years ago

Optimizing MySQL Query Performance with DESCRIBE and EXPLAIN

DESCRIBE and EXPLAIN statements are two of the most common statements that concerns MySQL performance issues. When you ask people…

5 years ago

InnoDB vs. MyISAM – Which One Should You Choose?

InnoDB and MyISAM are two of the most widely used MySQL storage engines. Each of them has its own pros…

5 years ago

MySQL Deadlocks 101

Sometimes when dealing with MySQL you might come across this slightly frustrating error: ERROR 1213 (40001): Deadlock found when trying…

5 years ago