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 (home) (work)
MySQL and RAM RequirementsAlexander Maret17 May
  • Re: MySQL and RAM RequirementsSasha Pachev17 May
  • MySQL and RAM RequirementsMichael Widenius24 May