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
2820
April 09, 2019 05:25AM
595
April 09, 2019 10:38AM
609
April 10, 2019 05:57AM
608
April 10, 2019 09:59AM
649
April 10, 2019 09:52PM
682
April 10, 2019 09:54PM
549
April 10, 2019 09:56PM
541
April 10, 2019 10:14PM
586
April 10, 2019 10:46PM
519
April 12, 2019 04:35AM
605
April 12, 2019 09:34AM
613
April 15, 2019 06:26AM
574
April 15, 2019 06:28AM
872
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.