MySQL Forums
Forum List  »  InnoDB

How to optimize/defragment RAM usage of mysqld
Posted by: Saravanan Balakrishnan
Date: February 17, 2016 01:39AM

Hello,

Problem:
There is an issue that RAM usage is too high for mysqld, it uses around 86% of memory. Following are the system information,

RAM : 48168.6M

Buffer pool config: innodb_buffer_pool_size=38534M


So from the above configuration that 80% of the RAM is allocation to the buffer pool to cache the data from the physical DB. We cannot change the innodb_buffer_pool_size as we need to support high availability and throughput time.

Query:

1. Is there a way to optimize the RAM usage of mysqld?
2. Is it possible that RAM get fragmented with huge transaction with update/insert/delete as it always reflects in both RAM and hard disk?
3. Can you please provide the De-fragmentation steps to perform it on the RAM to optimize the memory usage ?

For any other information needed please reply.
Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to optimize/defragment RAM usage of mysqld
1113
February 17, 2016 01:39AM


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.