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…
Today, the book I would like to recommend is Efficient MySQL Performance – Best Practices and Techniques, Daniel Nichter, O’Reilly, 2021. I participated (just a bit) in the writing of this book as technical reviewer with Vadim and Fipar. I…
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…
This is the first article of a new blog series related to MySQL books. Let’s start with MySQL Workshop, a practical guide to working with data and managing databases with MySQL written by Thomas Pettit and Scott Cosentino. The editor…
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]…