Hi Team,
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
Server configuration
36GB RAM, 64 bit Linux OS, 16 CPU.
MySQL configuration and status
innodb_buffer_pool_size = 6 GB
innodb_log_buffer_size=8MB
join_buffer_size=126KB
key_buffer_size=8MB
read_buffer_size=126KB
read_rnd_buffer_size=256KB
sort_buffer_size= 2MB
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.
regards
ramesh