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
Identifying Slow Queries in MySQL: Slow Query Log 101
When MySQL performance issues are encountered, one of the first things troubleshooting developers do is identify long running queries and optimize them. We will take
Read moreUnderstanding MySQL: The Power of Indexing
When talking about query optimization, indexing is one of the first topics that gets covered. In this post we will cover the types of indexes,
Read more
Slow SQL Queries? Don’t Blame MySQL (yet)
SQL queries being slow is one of the main complaints directed at MySQL. Why are queries slow? What’s making SQL queries slow? How to make
Read moreMySQL and Big Data – Mission Possible?
MySQL is a widely used open-source relational database management system. As much as this RDBMS is widely used though, in certain aspects it is frequently
Read more