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.
> Johan De Meersman さんは書きました:
>> ----- Original Message -----
>>> From: "Yu Watanabe" <yu.watanabe@stripped>
>>> 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=1
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/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc