What MySQL configuration you hate the most?
Kedar
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…
Browsing Category
MySQL
126 posts
Articles related to MySQL, Percona Server, MariaDB
MySQL Podcast: InnoDB Cluster Group Replication
I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…
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…
MySQL Data Archiving basics – considerations, mistakes, best practices
This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…