Change Is Inevitable
  • Home
  • MySQL
    • MySQL-Articles
    • AWS RDS
    • Percona Xtradb Cluster
    • MariaDB
    • Galera Cluster
    • ProxySQL
    • MySQL-Scripts
    • MySQL tools
    • MySQL Resources
  • Tools
    • MySQL Advisor
    • MySQL Random Data Generator
    • Postgresql Random Data Generator
    • Clean Prompt
  • General
    • binary-to-decimal
    • Fermat’s Theorem
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
    • MySQL Podcast (Youtube)
    • MySQL Podcast (Spotify)
Recent Posts
  • MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • How to setup and use Percona Binlog Server (PBS)
  • MySQL Major Version Upgrade Checklist – how to
  • InnoDB Flushing is simple – explained
  • MySQL Tools for Performance Tuning and Test Data Generation
Recent Comments
  • Kedar on MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • Jean-François Gagné on MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • Reggie on A Unique Foreign Key issue in MySQL 8.4
  • Kedar on How to fix write latency in MySQL 8.4 Upgrade
  • Kedar on How to fix write latency in MySQL 8.4 Upgrade
Home » MySQL » Page 2
Change Is Inevitable

Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects

  • Home
  • MySQL
    • MySQL-Articles
    • AWS RDS
    • Percona Xtradb Cluster
    • MariaDB
    • Galera Cluster
    • ProxySQL
    • MySQL-Scripts
    • MySQL tools
    • MySQL Resources
  • Tools
    • MySQL Advisor
    • MySQL Random Data Generator
    • Postgresql Random Data Generator
    • Clean Prompt
  • General
    • binary-to-decimal
    • Fermat’s Theorem
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
    • MySQL Podcast (Youtube)
    • MySQL Podcast (Spotify)

Browsing Category

MySQL

128 posts

Articles related to MySQL, Percona Server, MariaDB

MySQL Adaptive Hash Index
  • AWS RDS
  • MariaDB
  • MySQL
  • MySQL Upgrade
  • 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
Checksum on RDS MySQL
  • AWS RDS
  • MariaDB
  • MySQL
  • MySQL tools
  • 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
  • MariaDB
  • MySQL
  • 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
MySQL Podcast
  • MySQL
  • No comments

MySQL Podcast: InnoDB Cluster Group Replication

  • Kedar
  • September 15, 2025
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…
View Post
pmm-to-pmm-migration
  • MySQL
  • Percona Monitoring and Management
  • No comments

How to migrate PMM (Grafana) users

  • Kedar
  • August 4, 2025
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…
View Post
mysql8.4-foreign-keys
  • MySQL
  • MySQL Upgrade
  • 5 comments

A Unique Foreign Key issue in MySQL 8.4

  • Kedar
  • April 24, 2025
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…
View Post

Posts pagination

Previous 1 2 3 … 22 Next
MySQL Podcast (Youtube)
RSS feed: MySQL Podcast (Spotify) MySQL Podcast (Spotify)
  • MySQL Major Version Upgrade Checklist (Zero Downtime Strategy)
    Upgrading MySQL major versions in production is never just a version bump - it’s a carefully planned process involving compatibility checks, replication strategy, testing, and controlled cut-over.In this episode, we walk through a practical MySQL Major Version Upgrade Checklist based on real-world DBA workflows. We are covering MySQL replication as base setup for upgrade. It […]
Search:
... ...
  • MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • How to setup and use Percona Binlog Server (PBS)
  • MySQL Major Version Upgrade Checklist – how to
  • InnoDB Flushing is simple – explained
  • MySQL Tools for Performance Tuning and Test Data Generation

5 responses to “A Unique Foreign Key issue in MySQL 8.4”

  1. Reggie Avatar
    Reggie
    August 16, 2026

    Thanks for sharing this and reporting the bug.
    Equally fascinating is that the errors I receive, when trying to synchronise model with database, are against an FK that doesn’t exist, in the model or when inspecting the table information.

    Reply
  2. Rajaganesh G Avatar
    Rajaganesh G
    April 30, 2025

    Nice topic and clarified the doubt on foreign key.constraint issue. Good topic to go through once.

    Reply
    1. Kedar Avatar
      Kedar
      September 13, 2025

      Thanks Rajaganesh.

      Reply
  3. Anil Darnal Avatar
    Anil Darnal
    April 25, 2025

    thank you!

    Reply
    1. Kedar Avatar
      Kedar
      September 13, 2025

      Hey!!!!!! Hope you got chance to read 🙂

      Reply
Change Is Inevitable
Designed & Developed by Code Supply Co.