For this last technical post of the MySQL Community Advent Calendar 2022, I will explain how to grant privileges to users in MySQL 8.0. This is an important task for anyone who is responsible for managing a MySQL database, as it allows you to control which users have access to which parts of your database. […]

In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a…

The post Restore single MySQL table (ibd) from Xtrabackup (video demo) first appeared on Change Is Inevitable.

Since MySQL 8.0.30, the Dynamic InnoDB Redo Log is a new feature that allows users to resize the redo log files on the fly without the need for a restart. This is a significant improvement over previous versions of MySQL, where the redo log files had to be manually resized and the database had to […]

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant…

The post MySQL Interview – ChatGPT is not your DBA first appeared on Change Is Inevitable.

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 […]

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 […]

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