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. Thanks, Yu 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
