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…
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…
This post is the twelfth one of a series of articles on extending MySQL with the Component Infrastructure: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending…
This post is the second of a series of articles dedicated to MySQL Database Service (MDS): Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System Using MySQL Database Service in OCI – Part 2: importing…