MySQL Forums
Forum List  »  MyISAM

Severe Memory Loss
Posted by: Steve Williams
Date: November 29, 2005 04:17PM

I am running MYSQL VERSION: 4.1-14a
However, I have tested on other versions and the same problem persists.

I am running a large MYSQL table with about 25 fields and 400,000 records.

When I access this large table for the first time, for instance to "add a field to the table", or some like function, the server holds about 500mb of ram, and then never gives it back until the server is restarted. Is there anyway to get this mememory back (ie. re-free it up)?

I have already tried a mysqladmin flush tables. This really only helps slightly, to where I get back about 1% of what was held.

It would seem if MYSQL is reserving so much ram then running large MYSQL databases would be very RAM intensive...

Any thoughts?

Thanks,

Steve Williams



Edited 1 time(s). Last edit at 11/29/2005 04:17PM by Steve Williams.

Options: ReplyQuote


Subject
Views
Written By
Posted
Severe Memory Loss
2996
November 29, 2005 04:17PM
2025
November 30, 2005 05:49AM
1945
November 30, 2005 11:43AM
1914
December 01, 2005 10:15AM
1913
December 01, 2005 01:53PM
1898
December 02, 2005 08:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.