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 <[email protected]> > ----- Original Message ----- > > From: "Yu Watanabe" <[email protected]> > > > > 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/[email protected] > > -- Claudio
