Full table scans can be problematic for performance. Certainly if the scanned tables are large. The worst case is when full table scans are involved in joins and particularly when the scanned table is not the first one (this was…
This is the second article of the series dedicated to MySQL trending. As I wrote before, understanding your workload and seeing the evolution of it over time can help anticipating problems and work on solutions before the breakdown. This article…
We are getting many requests for migration from MariaDB to MySQL. Here is a quick guide and steps to follow: On the MariaDB server: Create a logical dump of MariaDB (using MySQL Shell) Create a dedicated user for replication [optional]…
In a previous post, I explained how you can collect and plot metrics using MySQL Shell. This is a new series of article where I will explain how to read and understand some of the generated graphs. Understanding your workload…
I could have also called this article When Pandas meet Dolphins in MySQL Shell. Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL. Since then, the MySQL…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.