Tag

Invisible Primary Key

0 views collected around this technical thread.

Aikesheng Open Source Community

Mar 4, 2024 · Databases

Can Disk Space Be Saved in MySQL by Adding a Primary Key?

The article demonstrates that adding an explicit primary key to a MySQL InnoDB table can dramatically reduce its on‑disk size by eliminating the hidden clustered index, and explains how invisible primary keys can be used when schema changes are not possible.

InnoDBInvisible Primary KeyMySQL

0 likes · 9 min read

Can Disk Space Be Saved in MySQL by Adding a Primary Key?

Aikesheng Open Source Community

Aug 2, 2022 · Databases

Using Generated Invisible Primary Keys (GIPK) in MySQL 8.0.30

This article explains the new MySQL 8.0.30 feature that automatically generates invisible primary keys for InnoDB tables without explicit primary keys, demonstrates how to enable and use it, discusses DDL and replication implications, and outlines related limitations and backup considerations.

BackupGIPKInnoDB

0 likes · 12 min read

Using Generated Invisible Primary Keys (GIPK) in MySQL 8.0.30