List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:November 24 2011 11:04am
Subject:Re: Data file for MyISAM engine
View as plain text  
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.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 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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Data file for MyISAM engineYu Watanabe23 Nov
  • Re: Data file for MyISAM engineJohan De Meersman23 Nov
    • Re: Data file for MyISAM engineClaudio Nanni23 Nov
      • Re: Data file for MyISAM enginemos23 Nov
    • Re: Data file for MyISAM engineYu Watanabe24 Nov
      • Re: Data file for MyISAM engineReindl Harald24 Nov
        • Re: Data file for MyISAM engineYu Watanabe24 Nov
          • Re: Data file for MyISAM engineReindl Harald24 Nov
          • Re: Data file for MyISAM engineJohan De Meersman24 Nov