Browsing Category

MariaDB

28 posts

Articles related to MariaDB

No comments

MySQL 8.4 disables AHI – Why and What you need to know

Kedar
January 19, 2026

MySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available…

View Post

No comments

How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4

Kedar
November 4, 2025

During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…

View Post

No comments

What MySQL configuration you hate the most?

Kedar
September 23, 2025

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…

View Post

6 comments

Killer Blog for MySQL Administrators

Kedar
December 9, 2024

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,…

View Post

3 comments

MySQL 8 utf8mb4_0900_ai_ci collation confusion

Kedar
November 18, 2024

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…

View Post

No comments

Podcast: Duplicate Indexes in MySQL

Kedar
November 14, 2024

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…

View Post