
MySQL
Why the Primary Key Is in Every Secondary Index
InnoDB stores the table inside its primary key. Almost every MySQL indexing consequence, good and bad, follows from that single decision.
· 3 min
category
InnoDB internals, locking, replication topologies and performance tuning for MySQL and MariaDB.
1 article

InnoDB stores the table inside its primary key. Almost every MySQL indexing consequence, good and bad, follows from that single decision.
· 3 min