MySQL Forums
Forum List  »  Memory Storage Engine

Memory Usage Excessive
Posted by: Bill Willits
Date: July 26, 2006 12:16AM

I am using 64bit Linux with 32Gb Ram with mysql v5.0.19. When I create and load Memory tables of about 2Gb each, the size of memory used by the mysqld process increases as expected. Here are the issues I am having.

1) The rate of growth of the memory used by mysqld does not seem to be in line with the size reported for the table(s) (data_length, index_length). The mysqld process grows at about double the rate of the memory table growth.

2) When I drop the memory tables, the memory used by mysqld does not reduce. This means that as I drop and recreate memory tables, the memory used on the server continues to grow, eventually using up all available memory and causing the server to crash.

Is there a fix for this behaviour? I need to rebuild my memory tables on a daily basis, and it invalidates the usefulness of the Memory engine if the memory cannot be reclaimed and reused.

Any help is much appreciated.
Bill Willits

Options: ReplyQuote

Written By
Memory Usage Excessive
July 26, 2006 12:16AM
July 31, 2006 01:12AM

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.