From: Reindl Harald
Date: November 24 2011 9:29am
Subject: Re: Data file for MyISAM engine
List-Archive: http://lists.mysql.com/mysql/226364
Message-Id: <4ECE0E7C.2040506@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigA5CCD172C701FDFBD4141E37"

--------------enigA5CCD172C701FDFBD4141E37
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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.
>=20
> Thank you for the reply.
> I see. So it will depend on the key buffer size.
>=20
> Thanks,
> Yu
>=20
> Johan De Meersman =E3=81=95=E3=82=93=E3=81=AF=E6=9B=B8=E3=81=8D=E3=81=BE=
=E3=81=97=E3=81=9F:
>> ----- 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=20
> 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=20
> storage allocation happens based off pages, not records, increases will=
 only happed when the existing pages are filling up.
>>
>>
>> --=20
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>
>> --=20
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dyu.watanabe@jp=
=2Efujitsu.com
>>
>>
>=20
>=20

--=20

Mit besten Gr=C3=BC=C3=9Fen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=C3=BChlgasse 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


--------------enigA5CCD172C701FDFBD4141E37
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7ODnwACgkQhmBjz394Ann/HgCbB3RlmL13dmmA/Tu5HP2zLXBt
MswAoIehk5gwVHoJa5Zm8o1FNesFEvN+
=4ksi
-----END PGP SIGNATURE-----

--------------enigA5CCD172C701FDFBD4141E37--