MySQL Forums
Forum List  »  Performance

Re: how mysql process resident memory is dependent on buffer pool size
Posted by: vivek d r
Date: October 09, 2012 04:17AM

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...

Options: ReplyQuote




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.