2022-11-30 mysql-Tuning InnoDB Primary Keys

悟世者

于 2022-11-30 17:33:18 发布

阅读量300

点赞数

分类专栏： mysql 文章标签： mysql 数据库 innodb

本文链接：https://blog.youkuaiyun.com/adofsauron/article/details/128119072

版权

mysql 专栏收录该内容

127 篇文章 ¥9.90 ¥99.00

订阅专栏

超级会员免费看

本文介绍了InnoDB存储引擎如何使用B-Tree存储数据，强调了定义显式主键的重要性。B-Tree是一种优化块设备操作的数据结构，尤其适用于处理磁盘延迟。有序插入时，InnoDB可以更有效地填充页面，减少后续更新导致的页分裂。随机插入会导致较低的页面填充率，增加存储需求。通过调整插入顺序，可以根据工作负载类型（如插入密集型或读取密集型）来优化性能和存储效率。

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

Tuning InnoDB Primary Keys - Percona Database Performance Blog

What is special about InnoDB primary keys?

InnoDB is called an index-organized storage engine. An index-organized storage engine uses the B-Tree of the primary key to stores the data, the table rows. That means a primary key is mandatory with InnoDB. If there is no primary key for a table, InnoDB adds a hidden auto-incremented 6 bytes counter to the table and use that hidden counter as the primary key. There are some issues with the InnoDB hidden primary key. You should always define explicit primary keys on your tables. In summary, yo