mysql innodb 主键

最新推荐文章于 2025-06-11 00:01:09 发布

原创最新推荐文章于 2025-06-11 00:01:09 发布 · 260 阅读

CC 4.0 BY-SA版权

文章标签：

30 篇文章

订阅专栏

本文介绍了MySQL InnoDB存储引擎中主键的设计原理及其对数据存储和索引的影响。主键决定了数据在主要数据文件中的物理存储顺序，并且复制到每个索引的每一行中，因此选择合适的主键类型对于提高查询效率至关重要。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://blog.johnjosephbachir.org/2006/10/22/everything-you-need-to-know-about-designing-mysql-innodb-primary-keys/
The primary key determines the order in which the data is physically stored in the main data file, aka “the clustered index”. Another way of saying this: the main data file is a B-tree index that directly contains all of a table’s columns, and the key on this B-tree is the primary key. This can result in one less I/O operation (compared to MyISAM) on many queries.
The primary key is what is used to associate all of a table’s indexes with the main data file. So the primary key is replicated in every row of every index.

如果不显示的指定主键的话，mysql会默认指定一个隐式的主键，而且是6字节的，

主键应该是有序的

主键应该越小越好，Because the primary key is replicated in every entry of every index,