In this new article about how to find the info when using MySQL Database Service on Oracle Cloud Infrastructure, we will learn about the query accelerator: HeatWave. With HeatWave, you can boost the performance of your MySQL queries, providing your applications with faster, more reliable, and cost-effective access to data. HeatWave is a high-performance in-memory […]

As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect. In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI. Secure Connections The first […]

For this third article of the series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure, we will see how we can find the error log. When using MySQL DBAAS, the DBA doesn’t have direct access to the files on the filesystem. Hopefully, with MySQL […]

The fourth edition of the MySQL Cookbook, solutions for database developers and administrators, Sveta Smirnova, Alkin Tezuysal, O’Reilly, 2022, is a huge book: 938 pages ! And the least we can say is that you get what you pay for ! This book is an excellent resource for anyone working with MySQL, whether you’re a […]

This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure. The first article was dedicated on Backups, this one is about Disk Space Utilization. This time we have two options to retrieve useful information related to disk […]

In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job. Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, … But as a serious DBA, you […]

I recently had the chance to read in preview Bill Karwin‘s new book: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming. This book is a rework of Bill’s best seller from 2010. The new book can be considered as the second edition and is updated with Bill’s latest observations about common mistakes. The […]

Today, the book I would like to recommend is Efficient MySQL Performance – Best Practices and Techniques, Daniel Nichter, O’Reilly, 2021. Best Practices and Techniques is a comprehensive guide to optimizing the performance of MySQL databases. Whether you’re a developer, database administrator, or system administrator, this book can provide valuable insights and techniques to help […]

For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. Is this related to the increase of microservices? In a microservices architecture, services are typically designed to be small, loosely coupled, and independently deployable. Each service may have its own database, which […]

InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!). If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages over MyISAM: <!– wp:list {"className":"","epStylingOptions":{"columnsResponsiveEnabled":false,"columnsHoverEnabled":false,"itemsSpacingResponsiveEnabled":false,"itemsSpacingHoverEnabled":false,"listStyleResponsiveEnabled":false,"listStyleHoverEnabled":false,"listIconResponsiveEnabled":false,"listIconHoverEnabled":false,"columns":{"target":"","responsive":true,"hover":true,"options":[{"custom":true,"control":"ToggleOptions"},{"label":"Columns","control":"Range","attribute":"columns","css":"grid-template-columns","customValue":"repeat({{value}}, …