MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: MySQL storage allocation
Posted by: Guisen Yang
Date: October 15, 2024 12:56AM

The '32 pages' here should refer to FSEG_SRAG_ARR in InnoDB, not the entire data file size.

If you are interested in the structure of IBD, you can take a look at ibd2sql(https://github.com/ddcw/ibd2sql). it us py3 to parse the structure of innodb file (xxx.ibd).

xfs struct: https://cdn.kernel.org/pub/linux/utils/fs/xfs/docs/xfs_filesystem_structure.pdf

Based on the above two, you can use to recover the drop table: https://cloud.tencent.com/developer/article/2457892

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.