The latest from the MySQL community

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post.

This blog post will describe how to start working with MySQL HeatWave in OCI. We will interconnect MySQL HeatWave instance with OCI Compute instance and even import data and execute SQL commands over them. First, I will describe the overall picture of what we want to achieve. Then I’ll walk you through the setup of […]

Connecting to MySQL HeatWave in OCI

When I’m working with MySQL, I care not just about whether a single query is slow, but how much total load the server can handle before performance starts to drop.

Tools like mysqlslap help by generating synthetic workloads to simulate multiple clients and measure the server’s Queries Per Second (QPS).

In this post, I’ll walk through a script I used to benchmark MySQL server performance with mysqlslap, and discuss when it makes sense to use it over more advanced tools like sysbench. I originally used this script in a blog post published at ReadySet: Vertical Scaling of MySQL vs. Horizontal Scaling with ReadySet.

Why Benchmark a MySQL Server?

Benchmarking gives a rough idea of how a MySQL server performs under …

Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At…

The post A Unique Foreign Key issue in MySQL 8.4 first appeared on Change Is Inevitable.

Recently, I encountered a Percona Monitoring and Management (PMM) server that was rapidly approaching complete disk exhaustion. This post outlines the steps taken to identify the issue and reclaim disk…

The post How to Resolve Disk Space Issues in PMM: Case Study first appeared on Change Is Inevitable.

When using the Percona Operator for MySQL based on Percona XtraDB Cluster (PXC), it’s common to encounter scenarios where cluster nodes request a full State Snapshot Transfer (SST) when rejoining the cluster. One typical scenario where a State Snapshot Transfer (SST) is required is when a node has been offline long enough that the GCache […]

This post is the second in a series about Routing Guidelines, a new feature available in both MySQL Community and Enterprise Editions that brings smarter and more flexible query routing to MySQL Architectures, including InnoDB Cluster, ClusterSet, and ReplicaSet. Whether you’re already using MySQL Router or evaluating ways to enhance and simplify application failover and scale workloads more efficiently, Routing Guidelines […]

Conference Presentations

This is the second part of our series on managing on-premises (External) MySQL DB systems in Oracle Cloud Infrastructure (OCI). In this blog, we cover the registration process, fleet monitoring, key metrics, alarms, and events to help you optimize performance and gain operational insights. Ensure that the prerequisites from the first part are completed and that you have the necessary permissions to proceed.