MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: MySQL storage allocation
Posted by: Guisen Yang
Date: October 10, 2024 08:03PM

The Blocks in stat are actually calculated for 512-bytes
/* Number of 512-byte blocks allocated */

and sometimes (like compressed table), size > blocks * 512, because hole punching
another, size < blocks * 512, because preallocate. `man relocated` to known more

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.