Re: Memory usage increasing constantly
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?
Subject
Written By
Posted
Re: Memory usage increasing constantly
May 09, 2014 03:01AM
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.