One of my MySQL server process is using more memory (around 75% resident memory) from RAM.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7622 mysql 15 0 32.8g 27g 5510 S 10.0 76.6 55493:27 mysqld
36GB RAM, 64 bit Linux OS, 16 CPU.
MySQL configuration and status
innodb_buffer_pool_size = 6 GB
Connections at a time = 500 (approx)
Query per Second = 4500 (approx)
Data size = 32 GB (approx)
Most of the tables are in InnoDB engine and the threads are accessing InnoDB tables. When I was looking Innodb status there is lack of free pages in buffer pool.
Is that the reason for using more memory from for MySQL Daemon ?
If I re-size innodb_buffer_pool_size to 16GB, do I get performance improvement ?
Total memory allocated 6593445888; in additional pool allocated 0
Dictionary memory allocated 2092044
Buffer pool size 393215
Free buffers 1
Database pages 388677
Old database pages 143456
Modified db pages 42657
Please suggest how to resolve this memory issue…
Let me know if there is any extra info required.