Re: how mysql process resident memory is dependent on buffer pool size

[vivek d r]

hi, i am using RHEL 5.7 OS

the physical RAM is 64 Gb on the server.



i have a sql which has data for a particular schema. the size of this sql file is 2gb.

before doing any operation on mysql, the memory usage will be around
#top

8339 mysql 15 0 5485m 1.6g 6956 S 0.0 6.9 4:34.26 mysqld

this 1.6GB is resident memory. now when i dump this data.sql into db.,. say like below

#mysql -uroot -ppassword dbName<data.sql

the resident memory will soar to around 8gb... thing is even after completion of dumping this data into db.. this resident memory will be stuck at 8GB, it wont drop down or say decompose back to 2gb or 1gb... that is this memory wont free up...