List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:May 17 1999 4:40pm
Subject:Re: MySQL and RAM Requirements
View as plain text  
Alexander Maret wrote:
> 
> Hi,
> 
> we installed a MySQL DB on a FreeBSD 3.1-Stable system.
> The system has 64MB ram and 128MB swap. The db we wanted
> to test MySQL on is about 70MB of size. If I do a
> "Select * from <table>" mysql uses 103MB of memory and
> doesn't stand another sql query. Now here is my question:
> What are the system requirements for a db with about
> 1GB of size? Or: how can I adjust ram-usage? Is there
> any config option to limit ram usage?
> 
> Alex
> 

Yes, it is documented in the manual. Try playing with
the sizes of different buffers.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
MySQL and RAM RequirementsAlexander Maret17 May
  • Re: MySQL and RAM RequirementsSasha Pachev17 May
  • MySQL and RAM RequirementsMichael Widenius24 May