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
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 and cons – we will
Read more
MySQL Deadlocks 101
Sometimes when dealing with MySQL you might come across this slightly frustrating error: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting
Read more