• Welcome to the world's largest Chinese hacker forum

    Welcome to the world's largest Chinese hacker forum, our forum registration is open! You can now register for technical communication with us, this is a free and open to the world of the BBS, we founded the purpose for the study of network security, please don't release business of black/grey, or on the BBS posts, to seek help hacker if violations, we will permanently frozen your IP and account, thank you for your cooperation. Hacker attack and defense cracking or network Security

    business please click here: Creation Security  From CNHACKTEAM

Recommended Posts

B+树能存多少数据?

fteoaximadu3173.png

图MySQL B树形图

InnoDB页面的默认大小为16KB:

假设记录大小为1KB,一个数据页可以存储16条数据(忽略页中的其他数据结构)。

假设主键为int,指针大小为6B,一个索引页可以存储16KB/(4B 6B)1638个索引。

因此,两层的B树可以存储:16*1638=26208条数据;第三级的B树可以存储:16*1638*1638=42928704条数据。

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now