Performance issues are often stubborn things to cure. Suddenly a query or operation seems slow, or slower-ish. Sadly, the database is often pointed at as the culprit by developers who are either positive their code cannot be at fault or those who see databases as a mysterious box that does odd things at the direction […]

The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. We can now start a query on our MDS instance that has been populated with >200M rows ...

CodeIgniter 4 Query Builder class has an update() function used to process UPDATE Data Manipulation Language (DML) commands. Using update() as a standalone function call is perfectly valid. However, there is also a set() function used for setting column values as you would with the SET keyword in an SQL UPDATE statement. Used in conjunction with the Query Builder where() function, you can easily UPDATE column values for an individual row or multiple rows. Continue reading for more information…

Image by  …

Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System in OCI is to use a parallel dump created using MySQL to Object Storage and load it during the creation of the MDS instance. MDS enables special features to increase the ingestion speed ...

During a recent Aurora MySQL 8 upgrade process, a number of validation checks have failed. This is an analysis of the error message “present in INFORMATION_SCHEMA’s INNODB_SYS_TABLES table but missing from TABLES table”.

MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries...

MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries. One – The MySQL Query Optimizer wants to optimize your […]

This post is the third and last of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. We can now start a query on our MDS instance that has been populated with >200M rows:  SQL > SELECT […]

This post is the second of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System […]

This post is the first of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. In this first article we will start by creating a MySQL DB System and a Compute instance in OCI. One of the […]