Memory usage increasing constantly
Posted by: Matteo Porru
Date: April 28, 2014 01:24AM

Hi,
For some reason my installation of MySQL is eating memory constantly. First it begins using the swap then after some time, when the swap used is more than 50% it becomes very slow.
I'm running MySQL CE 5.6.15 on RHEL6.3. My server has 6 GB RAM and 8GB swap space.
I have constantly around 150 alive connections to MySQL but I'm keeping max_connections to higher values to accomodate peaks and foresee some more traffic on this machine.
If I'm not wrong, doing some maths on the parameters I should be using around 95% of available RAM.
Am I missing something? My cnf below.
Thanks,
Matteo

---- my.cnf -----
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 64M
max_allowed_packet = 1M
table_open_cache = 256
key_buffer_size = 128M
sort_buffer_size = 524288
read_buffer_size = 131072
read_rnd_buffer_size = 524288
myisam_sort_buffer_size = 524288
tmp_table_size=10M
performance_schema=0
thread_cache_size = 50
query_cache_type = OFF
query_cache_size = 0
server-id = 1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

innodb_data_home_dir = "/data/mysqldata"
innodb_log_group_home_dir = "/data1/mysqllog"
innodb_buffer_pool_size = 3000M
innodb_buffer_pool_instances = 3
innodb_log_file_size = 750M
innodb_flush_log_at_trx_commit = 2
datadir = "/data/mysqldata"
innodb_flush_method=O_DIRECT

max_connections = 1650

slow_query_log = 1
slow_query_log_file = slow.log
long_query_time = 10

autocommit=1
init-connect='SET NAMES utf8'
character-set-server = utf8

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
default-character-set=utf8

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

---------

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.