MySQL Major Version Upgrade Checklist – how to
Kedar
This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task.
Browsing Tag
MySQL
79 posts
InnoDB Flushing is simple – explained
As a junior once I asked a seasoned MySQL DBA (Abuelo) “How do you stay so calm in critical situations?”Abuelo DBA then uttered golden words: “Son, I keep my dirty…
What MySQL configuration you hate the most?
Ever spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…
How to migrate PMM (Grafana) users
You’ve got a shiny new Percona Monitoring & Management instance standing by and want to move existing users over. This blog is a quick work around for migrating PMM users…
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…
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…