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 Tag
MySQL
77 posts
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…
Podcast: Duplicate Indexes in MySQL
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…