www.bortolotto.eu

Newsfeeds
Planet MySQL
Planet MySQL - https://planet.mysql.com

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

  • An Efficient Path to Learning MySQL Performance
    Conference Video Slides MySQL Performance for Application Developers @ MySQL and HeatWave Summit 2025† mysql-summit-2025.pdf MySQL Performance for Developers @ Percona Live 2023† PL23.pdf Efficient MySQL Performance @ Percona Live 2022 PL22.pdf Efficient MySQL Performance @ FOSDEM 2022 - † Video recording not available

  • Manage External MySQL DB systems in OCI
    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.