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)
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: