Killer Blog for MySQL Administrators
Kedar
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,…
Browsing Category
MySQL
114 posts
Articles related to MySQL, Percona Server, MariaDB
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…
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…
MySQL Podcast – Practical Learning & Training
Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…
MySQL Change Buffer – What When and FAQ
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…
Understanding Return Codes of pt-upgrade: A quick guide
Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…