Hi,
I am using Zabbix 4.2.6 on Centos 7.6.1810 and MySQL 5.7.27.
Mysql memory usage is increasing until it hits the RAM limit and starts using swap (attached file). The application and database are installed on the same server.
Any idea what is causing this memory consumption?
Details:
Memory usage for mysqld process:
[root@zabbix log]# cat /proc/1604/status | grep Vm
VmPeak: 7226772 kB
VmSize: 7095700 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 4881180 kB
VmRSS: 4719108 kB
VmData: 7041384 kB
VmStk: 132 kB
VmExe: 23484 kB
VmLib: 4240 kB
VmPTE: 10304 kB
VmSwap: 250088 kB
[root@zabbix log]# free -m
total used free shared buff/cache available
Mem: 7982 7396 243 11 342 287
Swap: 4095 720 3375
Environment:
60 servers monitored
Virtual Machine (ESXi):
8GB mem
4 vCPUs
80GB HD
Centos 7.6.1810
MySQL - mysql-community-server-5.7.27
Zabbix 4.2.6
80 VPS
MY.CNF:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
join_buffer_size = 2M
explicit_defaults_for_timestamp = 1
optimizer_switch = 'index_condition_pushdown=off'
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 2M
tmp_table_size = 256M
max_heap_table_size = 256M
thread_cache_size = 10
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 4
innodb_log_file_size = 512M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
symbolic-links=0
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE S
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thanks.
I am using Zabbix 4.2.6 on Centos 7.6.1810 and MySQL 5.7.27.
Mysql memory usage is increasing until it hits the RAM limit and starts using swap (attached file). The application and database are installed on the same server.
Any idea what is causing this memory consumption?
Details:
Memory usage for mysqld process:
[root@zabbix log]# cat /proc/1604/status | grep Vm
VmPeak: 7226772 kB
VmSize: 7095700 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 4881180 kB
VmRSS: 4719108 kB
VmData: 7041384 kB
VmStk: 132 kB
VmExe: 23484 kB
VmLib: 4240 kB
VmPTE: 10304 kB
VmSwap: 250088 kB
[root@zabbix log]# free -m
total used free shared buff/cache available
Mem: 7982 7396 243 11 342 287
Swap: 4095 720 3375
Environment:
60 servers monitored
Virtual Machine (ESXi):
8GB mem
4 vCPUs
80GB HD
Centos 7.6.1810
MySQL - mysql-community-server-5.7.27
Zabbix 4.2.6
80 VPS
MY.CNF:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
join_buffer_size = 2M
explicit_defaults_for_timestamp = 1
optimizer_switch = 'index_condition_pushdown=off'
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 2M
tmp_table_size = 256M
max_heap_table_size = 256M
thread_cache_size = 10
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 4
innodb_log_file_size = 512M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
symbolic-links=0
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE S
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thanks.
Attached Files