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

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

you should try to understand what pages are

your data + keys + fragmentation overhead if
deleted records are the size of the files

Am 24.11.2011 10:46, schrieb Yu Watanabe:
> Hi Reindl.
>=20
> Thanks for the reply.
>=20
> So, which memory corresponds to 'pages' for the MyISAM then?
> It would be helpful if you can help me with this.
>=20
> Reindl Harald =E3=81=95=E3=82=93=E3=81=AF=E6=9B=B8=E3=81=8D=E3=81=BE=E3=
=81=97=E3=81=9F:
>> 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 =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 n=
ot
>>>>> increasing after the insert sql.
>>>>
>>>> That's right, it's an L-space based engine; all the data that has, i=
s 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 t=
he index file. Both of those will increase with use, although=20
> since=20
>>> storage allocation happens based off pages, not records, increases wi=
ll 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.fujitsu.com
>>>>
>>>>
>>>
>>>
>>
>> --=20
>>
>> Mit besten Grusen, Reindl Harald
>> the lounge interactive design GmbH
>> A-1060 Vienna, Hofmuhlgasse 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
>>
>=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


--------------enigEFED43AB52DBD80A88AFCD19
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/

iEUEARECAAYFAk7OJNUACgkQhmBjz394Ann01QCXaIyYAXgOQdO40eFM+WVAWg4S
kQCeIR+nZMZbSI95OeA9aBvsxuIPXiw=
=SoJh
-----END PGP SIGNATURE-----

--------------enigEFED43AB52DBD80A88AFCD19--