Re: Memory usage increasing constantly
Posted by: Matteo Porru
Date: May 09, 2014 03:01AM

Ok, thank you for clarifying this.
But I still think there is something strange on this memory allocation.

I estimate the RAM usage with this formula:

key_buffer_size + query_cache_size + innodb_buffer_pool_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + innodb_dictionary_size + Max_used_connections * (read_buffer_size + read_rnd_buffer_size + sort_buffer_size+ join_buffer_size+ binlog_cache_size + thread_stack + tmp_table_size)

In this way we are considering the worst case of maximum connections, each one allocating the maximum possibile tmp_table_size.

With the numbers I have on my server the result is around 5.3 GB.
The actual memory allocation goes well over 9 GB, instead.

So either I'm not considering something relevant in my formula or there is a memory leak somewhere.
Any hints?

Options: ReplyQuote




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.