MySQL Forums
Forum List  »  Performance

Memory usage very high
Posted by: Glenn Reed
Date: January 26, 2009 10:03PM

Running an aggregrate query to populate a summary (counter) table takes several minutes to complete and uses a great deal of memory. All of 1.5 GB on my development machine.

I am summarizing a table with 12,000,000 rows into a in-memory table. The number of rows returned though should be small, about 5000 rows or such.

However when running the query it uses up all available memory on computer. Doesn't appear to crash but the memory is not reclaimed when the query finishes.

Is there a way to limit the amount of physical memory that mysqld allocates?

Regards
Glenn.

Options: ReplyQuote


Subject
Views
Written By
Posted
Memory usage very high
3482
January 26, 2009 10:03PM
1626
January 29, 2009 12:56AM


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.