High memory usage on mysql slave server
Hello Experts,
We have Master - Slave setup of MySQL 5.6.37 version.
On Slave server, memory usage is always showing high which is almost 98-99%.
This slave server is a virtual machine on VMware esxi host.
Slave server is having 16GB of memory allocated.
Below is the my.cnf :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir = /var/lib/mysqltemp
read-only = 1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
max_connections = 1000
server_id = 3
#
query_cache_size = 0
innodb_buffer_pool_size = 73G
innodb_log_file_size = 9G
innodb_buffer_pool_instances = 64
innodb_log_buffer_size = 8M
ignore-db-dir=lost+found
[mysqld_safe]
log-error=/usr/binlogs/aws_mysql_slave-mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/lib/mysql/mysql.sock
#
[mysql]
socket=/var/lib/mysql/mysql.sock
####
Please help me to troubleshoot this issue.
Subject
Views
Written By
Posted
High memory usage on mysql slave server
3406
April 09, 2019 05:25AM
798
April 09, 2019 10:38AM
805
April 10, 2019 05:57AM
834
April 10, 2019 09:59AM
886
April 10, 2019 09:52PM
881
April 10, 2019 09:54PM
803
April 10, 2019 09:56PM
745
April 10, 2019 10:14PM
817
April 10, 2019 10:46PM
696
April 12, 2019 04:35AM
828
April 12, 2019 09:34AM
837
April 15, 2019 06:26AM
811
April 15, 2019 06:28AM
1167
April 15, 2019 08:31AM
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.