key buffer is memory and has nothing to do with file sizes filesize increeases by data and keys key buffer is as the name says a memory-buffer for kyes
Am 24.11.2011 10:25, schrieb Yu Watanabe: > 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 >> >> > > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature