List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 23 2011 7:25am
Subject:Re: Data file for MyISAM engine
View as plain text  
----- Original Message -----
> From: "Yu Watanabe" <yu.watanabe@stripped>
> 
> It seems that MYD is the data file but this file size seems to be not
> increasing after the insert sql.

That's right, it's an L-space based engine; all the data that has, is and will ever be
created is already in there, so storage never increases :-p

Seriously though; the MYD file is the datafile and the MYI file is the index file. Both of
those will increase with use, although since storage allocation happens based off pages,
not records, increases will only happed when the existing pages are filling up.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
Data file for MyISAM engineYu Watanabe23 Nov
  • Re: Data file for MyISAM engineJohan De Meersman23 Nov
    • Re: Data file for MyISAM engineClaudio Nanni23 Nov
      • Re: Data file for MyISAM enginemos23 Nov
    • Re: Data file for MyISAM engineYu Watanabe24 Nov
      • Re: Data file for MyISAM engineReindl Harald24 Nov
        • Re: Data file for MyISAM engineYu Watanabe24 Nov
          • Re: Data file for MyISAM engineReindl Harald24 Nov
          • Re: Data file for MyISAM engineJohan De Meersman24 Nov