From: Claudio Nanni Date: November 23 2011 8:45am Subject: Re: Data file for MyISAM engine List-Archive: http://lists.mysql.com/mysql/226358 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf306f7224f8b36204b262f1c7 --20cf306f7224f8b36204b262f1c7 Content-Type: text/plain; charset=ISO-8859-1 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 > ----- Original Message ----- > > From: "Yu Watanabe" > > > > 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.nanni@stripped > > -- Claudio --20cf306f7224f8b36204b262f1c7--