List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:November 23 2011 8:45am
Subject:Re: Data file for MyISAM engine
View as plain text  
Also,
since MySQL 5.1 MyISAM has an algorythm to detect if you are going to
delete a row without ever reading it,
so when you insert it, it will use the blackhole storage engine instead.
 :O   (NB: it is a joke)

Claudio


2011/11/23 Johan De Meersman <vegivamp@stripped>

> ----- 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Claudio

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