In this blog, we will discuss what UUIDs are and how to use them in MySQL 8.0. We will also explore the advantages and disadvantages of using UUIDs and their different types.  Whether you are new to UUIDs or an experienced user, this blog will provide valuable insights and tips for using UUIDs in MySQL […]

In this blog post, we will discuss how to display long transactions in MySQL 8.0. Having transactions running for a long time can lead to performance issues and can cause the database to become unresponsive. In order to avoid these issues, it is important to monitor and manage long transactions in your database. In this […]

MySQL Community Advent Calendar 2022 - How to generate a slow query log using MySQL Shell on Oracle Cloud Infrastructure (OCI) MySQL HeatWave. The slow query log is a valuable tool for identifying and troubleshooting performance issues with MySQL database queries.

Apache Airflow is a powerful tool for managing and scheduling data pipelines. It allows you to define your data processing workflows as directed acyclic graphs (DAGs) and manage their execution in a scalable and reliable manner. In this blog, I will explain how to deploy Apache Airflow on Oracle Cloud Infrastructure (OCI) with MySQL HeatWave […]

In this blog post, we explore how MySQL 8.0 handles dates that are input incorrectly. This is an important topic to understand, as incorrect dates behaves differently between MySQL 5.x and MySQL 8.0. In MySQL 8.0, when using invalid values for date data types, an error is returned. This was not the case in 5.x […]

Part of the MySQL Community Advent Calendar 2022, I wrote three articles on how to analyze queries and generate a slow query log for MySQL Database Service on OCI: https://blogs.oracle.com/mysql/post/analyzing-queries-in-mysql-database-service https://blogs.oracle.com/mysql/post/generate-slow-query-log-mysql-heatwave-part1 https://blogs.oracle.com/mysql/post/generate-slow-query-log-mysql-heatwave-part2 In these post, we were generating a slow query log in text or JSON directly in Object Storage. For today’s post, we will […]

Using MySQL Shell, we can import JSON data into JSON column in a database table. Take a look at the steps involved.

In my previous post about InnoDB Stalls on Empty Free List, I used a test environment that might look a little artificial : a table larger than the InnoDB Buffer Pool but fitting in the Linux Page Cache.  This configuration allows serving very quickly what MySQL thinks are IOs because these are hit in the filesystem cache.  In this post, I explain why this environment is not

Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in a controlled manner that does not disrupt application users or cause application downtime.

One of the tools in Percona Toolkit is pt-online-schema-change, a utility that alters the structure of a table without interfering with the reads or writes. The tool creates an empty copy of the table to alter and modify as desired before copying the rows from the original table into the new one.

When the copying is finished, it removes the original table and replaces it with the new one. Any changes made to data in the original tables during the copy process will be reflected in the new table as the tool creates triggers on …

We recently released Read Replica for MySQL HeatWave Database Service. Read Replicas are read-only copies of the MySQL DB system in the same region. When you add Read Replicas, they are automatically distributed accross Availability Domains and/or Fault Domains. Each MySQL DB instance can have up to 18 read replicas. Read Replicas use MySQL Asynchronous […]