Memory: Correlate prstat with NDB Config values
Posted by: Gord Taylor
Date: July 20, 2015 05:32PM

I need to upgrade the memory of my Solaris MySQL Cluster. I know my NDB Nodes are running low on memory but I can't seem to get a good correlation between `prstat -s rss` and the values in my management server's config.ini file.

The config.ini shows:

SendBufferMemory=4M
ReceiveBufferMemory=4M
DataMemory=5004M
IndexMemory=883M
SharedGlobalMemory=1024M
# DiskPageBufferMemory=2048M
StringMemory=25
TransactionBufferMemory=8M

And when I go on one of my nodes (All 6 report the same total memory of 7781) and run `prstat -s rss` I see the following:

PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
76717 root 7781M 7575M sleep 6 0 785:06:54 1.5% ndbd/40


When I add up the memory in the config file I get 6952M. Why do I not get 7781M?

Can someone please help me find the most accurate correlation of memory between prstat and the config file?

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Memory: Correlate prstat with NDB Config values
3240
July 20, 2015 05:32PM


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.