Mailing List Archive


Back to the month index Back to the list index
Vivek Khera (khera@kci.kciLink.com)
Wed, 29 Jan 1997 14:13:59 -0500 

Message-Id: <199701291913.OAA19323@kci.kciLink.com>
Subject: Re: [mSQL] 1.0.16 not freeing memory 
Date: Wed, 29 Jan 1997 14:13:59 -0500
From: Vivek Khera <khera@kci.kciLink.com>

+---------
| We are running 1.0.16 on BSD/OS 2.1. Whenever I do a select on any
| database that has over a thousand records or so msql grabs the same amount
| of memory that the physical database file actually uses on disk, and when
| the query is done, it never releases the memory. I saw this bug mentioned
| in the FAQ, but at least on our system it shows up in such small databases
| that it makes msql unusable.
+---------

Not a bug, but a feature (sorta). mSQL uses mmap() to map the data, and on
BSD/OS that shows up in the virtual memory size of the process.

If you check the amount of actual VM available to the system, it should be
normal.

                                                                v.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-258-8292
PGP/MIME spoken here http://www.kciLink.com/home/khera/
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!