Hello Johan. Thank you for the reply. I see. So it will depend on the key buffer size.
Thanks, Yu Johan De Meersman さんは書きました: >----- 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=yu.watan...@jp.fujitsu.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql