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. > > Thanks for the reply. > > So, which memory corresponds to 'pages' for the MyISAM then? > It would be helpful if you can help me with this. > > Reindl Harald さんは書きました: >> 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 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 >> > > -- 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
