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 <vegiv...@tuxera.be> > ----- Original Message ----- > > From: "Yu Watanabe" <yu.watan...@jp.fujitsu.com> > > > > 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=claudio.na...@gmail.com > > -- Claudio
