maximum memory used by mysql

[Bernd Jagla]

Hi there,

I working on a databank project in the field of cancer research and I need some advice....

my databank is growing quite fast, and I want to upgrade my SGI (Origin 2000) system to
keep up with the amount of data created.
I thought of increasing the memory to a total of about 11 GB. Now I am wondering if mysql
can actually make use of all this memory, or if there is a better way to keep up...

I would be very thankfull if you could help me with some ideas, experience or other
suggestions on how to cope with quite big tables (>300,000,000 entries).

Thank you very much in advance for your kind help

Bernd
 
     =====================================================================
     
     Please note that this e-mail and any files transmitted with it may be 
     privileged, confidential, and protected from disclosure under 
     applicable law. If the reader of this message is not the intended 
     recipient, or an employee or agent responsible for delivering this 
     message to the intended recipient, you are hereby notified that any 
     reading, dissemination, distribution, copying, or other use of this 
     communication or any of its attachments is strictly prohibited.  If 
     you have received this communication in error, please notify the 
     sender immediately by replying to this message and deleting this 
     message, any attachments, and all copies and backups from your 
     computer.