Big Data + MySQL = Mission InnoPossible?
Sometimes MySQL (or MariaDB) can be great for big data too! In this article, we will explore the things you should consider when answering the question: “Is MySQL a good option for my big data project?”
Sometimes MySQL (or MariaDB) can be great for big data too! In this article, we will explore the things you should consider when answering the question: “Is MySQL a good option for my big data project?”
The first thing to look at to start optimizing a query is the Query Planner. In this post we will explain how a query gets executed and how to understand the EXPLAIN command.
Learn how deadlocks may be impacting your database performance, and how you can resolve them
Deleted records from your database could still be taking up space on your disk. Learn how to use VACUUM to reduce size and improve performance of your databases.
Your intuition about indexing might be broken. Here's how to use indexing to optimize database search performance.