Re: Memory keeps increasing causing a restart

[Liping Gao]

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
sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

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

[mysqldump]
quick
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