>Hi all
>
>I have a large table (20 million records) that I want to load into RAM to
>improve selects. I understand (from previous posts) that I must create a
>HEAP table. Please correct me if I'm wrong on this. My question is - how
>much RAM do I need if the MYI and MYD files are as follows :-
>
>214M Jan 20 19:11 domain0115.MYI
>680M Jan 20 19:11 domain0115.MYD
>
>Those sizes are in Mega bytes. Does the RAM size have to provide for both
>the MYI and MYD files?
Yes. You will need around 1gig available mem to load that table! You have not included
the structure of the table, so the table could have fixed row lengths. This can make a
table very large indeed. Are you using varchar or char columns?
>Also, is it correct that the MYD is the datafile and MYI the index file?
Yes.
--
Richard Ellerbrock
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
