My Oracle Support Banner

Find Out Tables Without Primary Key or Unique Keys Which All Included Columns Are NOT NULL (Doc ID 2940270.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Goal

 Tables without a primary key or unique keys which all included columns are NOT NULL (primary key equivalents) often cause problems on replication, especially when the binlog_format is ROW; which causes slowness on the replicas. Such tables cannot be used in Group Replication. This document describes how to find out such tables using information schema views.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.