From: Johan De Meersman
Date: November 24 2011 3:19pm
Subject: Re: Data file for MyISAM engine
List-Archive: http://lists.mysql.com/mysql/226368
Message-Id: <62776de7-a625-442b-8741-6eb9be8efab6@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
----- Original Message -----
> From: "Yu Watanabe"
>
> So, which memory corresponds to 'pages' for the MyISAM then?
> It would be helpful if you can help me with this.
None, as Reindl said. This is not a memory issue, it's a function of I/O optimization. Records are stored in pages, and pages are composed of multiple disk blocks. The database reads or writes only entire pages, in order to better use the system's disk throughput.
This is a reasonably advanced topic, so don't try to mess with block and page sizes if you don't know the fine details :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel