MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: MySQL storage allocation
Posted by: S.M. Gopinath
Date: October 14, 2024 11:44PM

Thanks for the details.


https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html

As per above link, when a table created first 32 pages is allocated, that means 16384(16k) * 32 = 512 kb, but the size of the ibd file is only 112k, this is confusing again, any insights on this?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL storage allocation
S.M. Gopinath
October 10, 2024 07:43AM
Re: MySQL storage allocation
Guisen Yang
October 10, 2024 08:03PM
Re: MySQL storage allocation
S.M. Gopinath
October 14, 2024 11:44PM
Re: MySQL storage allocation
Guisen Yang
October 15, 2024 12:56AM
Re: MySQL storage allocation
S.M. Gopinath
October 15, 2024 08:52AM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.