Re: Memory keeps increasing causing a restart
Posted by: Liping Gao
Date: June 29, 2015 12:39PM

We have fairly small setting for the buffers size but the memory keeps increasing also. For total 3.6G data with below setup, the memory usage could keep increased to be 16G and we have to schedule an emergency reboot in order to avoid the automatic restarting of the server.

Is there any way to CAP the mysql memory usage? Is it a bug in MySQL 5.6 on Solaris?

# innodb management parameter

innodb_buffer_pool_size = 3G #(50-80% of RAM, default 8M)
innodb_log_file_size = 250M #(25% of buffer pool, default 48M)
innodb_flush_log_at_trx_commit = 0 #flush each second, default is 1
innodb_thread_concurrency = 6 #(2 times of CPUs plus disks)
innodb_file_per_table = 1 #one innodb file for one table
innodb_purge_threads = 4 #default is 1
innodb_undo_tablespaces = 4 #default is 0, only at create time
innodb_undo_logs = 8 #default is 128

explicit_defaults_for_timestamp = TRUE

# reporting variables
join_buffer_size = 2M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M

# parameters for security
local-infile = 0
secure-auth = ON

host_cache_size = 0 #Disable host caching for DNS resolution

# expire binary logs after three days
expire_logs_days = 3

# max concurrency connection on the server
max_connections = 500

max_allowed_packet = 256M

[mysql] # mysql client
prompt = \\u@\\h [\\d]>\\_
no-auto-rehash #Disables auto table/column name completion, MySQL runs faster

[mysqld] # mysql server
max_allowed_packet = 256M

Options: ReplyQuote

Written By
Re: Memory keeps increasing causing a restart
June 29, 2015 12:39PM

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.