Memory leak in Mysql server.

[sathish kumar]

Hi All,

I’m facing issues with Mysql that It eats out my server’s main memory (really it’s not an issue). When the memory gets eaten by it fully, at last it throws an error “out of memory”. To avoid this error, I would need to restart the Mysql server within a period of time according the memory usage. So it releases all memory and starts working normally as a new start.

“Memory leak” in my Mysql server.

Hopefully, we can fix it up by tuning the Mysql and its configurations well done. Can anyone please suggest me, what kind of measurement I would need to take and implement it.

Here are few Mysql configuration values listed below as per my Server,

key_buffer_size = 256M #600
max_join_size = 16M
max_connections = 500
max_connect_errors = 9999999 #10
table_cache = 2048
max_allowed_packet = 16M

open_files_limit = 4096
# this is the in-memory tmp table max size
max_heap_table_size = 64M
# below are per-connection and per-sub-query
join_buffer_size = 8M #4M
read_buffer_size = 4M
#write_buffer_size = 4M
sort_buffer_size = 8M
myisam_sort_buffer_size = 128M
read_rnd_buffer_size=8M #3072K
thread_cache_size=16 #8
thread_concurrency = 8 # 4
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
query_cache_size = 128M
query_cache_limit = 4M
thread_stack = 192K
transaction_isolation = READ-COMMITTED
# this is the on-disk max size
tmp_table_size = 128M


Awaiting for your valuable suggestions eagerly,

Thanks in Advance,

Sathish Kumar S



Edited 1 time(s). Last edit at 04/15/2010 03:04AM by sathish kumar.