----- 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=arch...@jab.org
