How to optimize/defragment RAM usage of mysqld

[Saravanan Balakrishnan]

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.