Hello,
I configurated the /etc/my.cnf to my server, because the MySQL was not killing the process and even freezing my machine sometimes with the memory usage.
But, with the configuration I did, looks like the memory usage still increasing, even when the mysql processes are being killed.
The configuration of /etc/my.cnf:
[mysqld]
innodb_file_per_table=1
set-variable = max_connections=1000
key_buffer =2048M
table_cache = 36272
open_files_limit = 16344
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 8M
tmp_table_size=512M
read_rnd_buffer_size=8M
max_heap_table_size=256M
myisam_sort_buffer_size=256M
thread_cache_size=8
thread_cache=8192
query_cache_type=1
query_cache_limit=512M
query_cache_size=1024M
thread_concurrency = 8
wait_timeout = 10
connect_timeout = 10
interactive_timeout = 10
long_query_time=1
log-slow-queries = /var/log/mysqlslowqueries.log
max_allowed_packet=128M
My server is one i7-2600K CPU @ 3.40GHz with 32Gb RAM and I don't know what to do to stop the memory usage increasing.
Any help?
Regards,
Fabio Morais
I configurated the /etc/my.cnf to my server, because the MySQL was not killing the process and even freezing my machine sometimes with the memory usage.
But, with the configuration I did, looks like the memory usage still increasing, even when the mysql processes are being killed.
The configuration of /etc/my.cnf:
[mysqld]
innodb_file_per_table=1
set-variable = max_connections=1000
key_buffer =2048M
table_cache = 36272
open_files_limit = 16344
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 8M
tmp_table_size=512M
read_rnd_buffer_size=8M
max_heap_table_size=256M
myisam_sort_buffer_size=256M
thread_cache_size=8
thread_cache=8192
query_cache_type=1
query_cache_limit=512M
query_cache_size=1024M
thread_concurrency = 8
wait_timeout = 10
connect_timeout = 10
interactive_timeout = 10
long_query_time=1
log-slow-queries = /var/log/mysqlslowqueries.log
max_allowed_packet=128M
My server is one i7-2600K CPU @ 3.40GHz with 32Gb RAM and I don't know what to do to stop the memory usage increasing.
Any help?
Regards,
Fabio Morais