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…
Killer Blog for MySQL Administrators
This is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…
MySQL 8 utf8mb4_0900_ai_ci collation confusion
Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…
AI tools – technology and kids
AI tools like ChatGPT, GROK, Meta and Gemini are taking off, and as parents, it’s easy to feel the pressure to keep our kids up to speed. The message out…