List:Cluster« Previous MessageNext Message »
From:Hendrik Woltersdorf Date:June 25 2013 11:12am
Subject:RAM usage of MySQL cluster SQL nodes
View as plain text  
Hi,

I have a cluster at version 7.2.8 where the two SQL nodes use _very_ 
different amounts of RAM.

One 1.4GB, the other 12GB as shown by top:

top - 13:04:48 up 255 days,  2:02,  1 user,  load average: 0.38, 0.40, 0.38
Tasks: 203 total,   1 running, 202 sleeping,   0 stopped,   0 zombie
Cpu(s):  1.7%us,  0.5%sy,  0.0%ni, 97.6%id,  0.0%wa,  0.0%hi, 0.2%si,  
0.0%st
Mem:  28825436k total, 28488168k used,   337268k free,   363136k buffers
Swap:  4192956k total,      176k used,  4192780k free, 13334488k cached

   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
19297 mysql     15   0 13.3g  12g 8528 S   11 45.4  19988:40 mysqld

Here are some of the memory relevant settings from my.cnf:

query_cache_size=0
table-open-cache=1024
innodb_buffer_pool_size=8M

#OTHER THINGS, BUFFERS ETC
key_buffer_size = 256M
max_allowed_packet = 16M
sort_buffer_size = 512K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
thread_cache_size=1024
myisam_sort_buffer_size = 8M
memlock=0

There are about 230 open client connections to each SQL node.

Any ideas, why one of the SQL nodes uses so much RAM?

regards,
Hendrik Woltersdorf

XCOM AG
Softwareentwicklung
Banksystem Front- und Middleoffice
Peter-Breuer-Str. 13
08056 Zwickau
Germany

Telefon +49 375 27008-580
Telefax +49 375 27008-25
Mobil   +49 152 22999 584
hendrik.woltersdorf@stripped
http://www.xcom.de

Thread
RAM usage of MySQL cluster SQL nodesHendrik Woltersdorf25 Jun