MySQL Forums
Forum List  »  NDB clusters

Memory exhausted on one node
Posted by: Stephen(Tie) Hu
Date: June 05, 2005 08:13PM

Hi,
I am useing mysql cluster on our production platform. I established two nodes(ndb and sql) with one management node. But recently when I was monitoring the resource consumption of the two servers, I found out that the 'mysqld' process of master node will continuously consume the physical memory until it is used up, but another node will not. When they are first initialized there is alway 500M~800M free memory, but only after 3 or 5 days the master node will used up all free memory, but I think it can still work, but the speed is not as fast as it was initialized.

Any experience or idea? Thanks a lot!
See the following information generated by top:

Node 1:
-----------------------------------------
Tasks: 37 total, 2 running, 35 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.3% us, 0.0% sy, 0.0% ni, 97.0% id, 2.3% wa, 0.3% hi, 0.0% si
Mem: 2075664k total, 2023264k used, 52400k free, 59584k buffers
Swap: 2096472k total, 486748k used, 1609724k free, 139232k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
15567 mysql 21 0 2168 928 792 S 0.0 0.0 0:00.00 mysqld_safe
15580 mysql 16 0 2102m 1.5g 4324 S 0.0 77.7 6:04.47 mysqld
22457 mysql 16 0 6280 2740 1324 S 0.0 0.1 0:00.00 ndbd
22458 mysql 15 0 1045m 146m 2252 S 0.0 7.3 6:04.29 ndbd

Node 2:
-----------------------------------------
Tasks: 37 total, 2 running, 35 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.7% us, 0.3% sy, 0.0% ni, 96.7% id, 2.3% wa, 0.0% hi, 0.0% si
Mem: 2075664k total, 1544616k used, 531048k free, 350840k buffers
Swap: 2096472k total, 0k used, 2096472k free, 839992k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13748 mysql 16 0 135m 23m 4360 S 0.7 1.1 5:06.46 mysqld
18167 mysql 15 0 1045m 201m 2364 S 0.3 10.0 7:35.71 ndbd
13735 mysql 16 0 4860 1064 916 S 0.0 0.1 0:00.00 mysqld_safe
18166 mysql 16 0 6280 2844 1392 S 0.0 0.1 0:00.00 ndbd

Options: ReplyQuote


Subject
Views
Written By
Posted
Memory exhausted on one node
3805
June 05, 2005 08:13PM
2804
June 06, 2005 07:43PM
2116
June 07, 2005 07:56AM
2151
June 07, 2005 08:03AM
2012
June 07, 2005 08:57AM
3246
June 20, 2005 09:17AM


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.