In this blog, we tell you it all about composite indexes – what they are, how they work, and when should they be used.
Read more
MyISAM vs. InnoDB: The Problem
In this blog post, we tell you how does MyISAM compare with InnoDB.
Read more
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 you what they are, and how best to work with them.
Read more
The MySQL Server – mysqld
In this blog, we discuss the ins and outs of the MySQL daemon and tell you how best to improve MySQL performance & security.
Read more
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 a list of best practices
Read more
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 phenomena called the Schrödinger’s cat.
Read more
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 security experts, company associates and
Read more
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 not function – we will
Read more
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 how to optimize a query,
Read more