Alexander Maret wrote:
> 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?
Yes, it is documented in the manual. Try playing with
the sizes of different buffers.