|
Planet MySQL
|
Planet MySQL - https://planet.mysql.com
|
-
Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)
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 with being known since 16 Jul 2024, has not been talked about much, so this deserves a blog post.
-
Connecting to MySQL HeatWave in OCI
Connecting to MySQL HeatWave in OCI
-
A Unique Foreign Key issue in MySQL 8.4
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.
-
How to Resolve Disk Space Issues in PMM: Case Study
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.
-
Speeding Up Percona XtraDB Cluster State Transfers with Kubernetes Volume Snapshots
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 […]
|
