计算cluster的内存使用量

kerlion

执行效果这样的

1. ndb_memsize.sh  11
   
2. KB:1024 MB:1048576 GB:1073741824
   
3. MaxNoOfAttributes........................ (MB): 156
   
4. MaxNoOfTables............................ (MB): 160
   
5. MaxNoOfOrderedIndexes.................... (MB): 195
   
6. MaxNoOfUniqueHashIndexes................. (MB): 80
   
7. MaxNoOfConcurrentOperations.............. (MB): 2048
   
8. TransactionBufferMemory.................. (MB): 1
   
9. IndexMemory.............................. (MB): 1200
   
10. DataMemory............................... (MB): 12000
    
11. UndoIndexBuffer.......................... (MB): 2
    
12. UndoDataBuffer........................... (MB): 16
    
13. RedoBuffer............................... (MB): 32
    
14. LongMessageBuffer........................ (MB): 4
    
15. DiskPageBufferMemory..................... (MB): 64
    
16. SharedGlobalMemory....................... (MB): 20
    
17. BackupMemory............................. (MB): 32
    
18. 
    
19. ******Total Memory size: 15.63GB******

复制代码

kerlion

1. #!/bin/bash
   
2. 
   
3. usage()
   
4. {
   
5.    echo "-----------------------------"
   
6.    echo "Usage:$(basename $0) NodeId"
   
7.    echo "-----------------------------"
   
8.    echo
   
9.    exit 1
   
10. }
    
11. 
    
12. print_size ()
    
13. {
    
14. string1=$(echo $1|sed -e :a -e 's/^.\{1,40\}$/&./;ta')
    
15. echo -e "$string1 (MB):\t$2"
    
16. }
    
17. 
    
18. 
    
19. 
    
20. if [ "$1" == "" ]; then
    
21.     usage
    
22. fi
    
23. string1=$(echo $1|egrep "^[0-9]+$")
    
24. if [ "$1" != "$string1" ]; then
    
25.     usage
    
26. fi
    
27. 
    
28. 
    
29. 
    
30. GETVAL="ndb_config  --id=$1 -q"
    
31. #ndb_config  --id=12 -q MaxNoOfAttributes
    
32. ksize=1024
    
33. msize=$(echo "scale=2; 1024*1024" | bc -l 2>/dev/null)
    
34. gsize=$(echo "scale=2; 1024*1024*1024" | bc -l 2>/dev/null)
    
35. echo "KB:$ksize MB:$msize GB:$gsize"
    
36. 
    
37. MEMSIZE=0
    
38. 
    
39. #Attributes
    
40. TSIZE=$($GETVAL MaxNoOfAttributes)
    
41. TSIZE=$(echo "scale=0; $TSIZE*200" | bc -l 2>/dev/null)
    
42. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
43. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
44. print_size "MaxNoOfAttributes" $TSIZE
    
45. 
    
46. 
    
47. #Attributes
    
48. TSIZE=$($GETVAL MaxNoOfTables)
    
49. TSIZE=$(echo "scale=0; $TSIZE*20*$ksize" | bc -l 2>/dev/null)
    
50. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
51. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
52. print_size "MaxNoOfTables" $TSIZE
    
53. 
    
54. 
    
55. #Attributes
    
56. TSIZE=$($GETVAL MaxNoOfOrderedIndexes)
    
57. TSIZE=$(echo "scale=0; $TSIZE*10*$ksize" | bc -l 2>/dev/null)
    
58. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
59. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
60. print_size "MaxNoOfOrderedIndexes" $TSIZE
    
61. 
    
62. #Attributes
    
63. TSIZE=$($GETVAL MaxNoOfUniqueHashIndexes)
    
64. TSIZE=$(echo "scale=0; $TSIZE*10*$ksize" | bc -l 2>/dev/null)
    
65. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
66. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
67. print_size "MaxNoOfUniqueHashIndexes" $TSIZE
    
68. 
    
69. 
    
70. 
    
71. #Attributes
    
72. TSIZE=$($GETVAL MaxNoOfConcurrentOperations)
    
73. TSIZE=$(echo "scale=0; $TSIZE*1*$ksize" | bc -l 2>/dev/null)
    
74. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
75. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
76. print_size "MaxNoOfConcurrentOperations" $TSIZE
    
77. 
    
78. #Attributes
    
79. TSIZE=$($GETVAL TransactionBufferMemory)
    
80. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
81. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
82. print_size "TransactionBufferMemory" $TSIZE
    
83. 
    
84. #Attributes
    
85. TSIZE=$($GETVAL IndexMemory)
    
86. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
87. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
88. print_size "IndexMemory" $TSIZE
    
89. 
    
90. #Attributes
    
91. TSIZE=$($GETVAL DataMemory)
    
92. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
93. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
94. print_size "DataMemory" $TSIZE
    
95. 
    
96. #Attributes
    
97. TSIZE=$($GETVAL UndoIndexBuffer)
    
98. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
    
99. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
    
100. print_size "UndoIndexBuffer" $TSIZE
     
101. 
     
102. #Attributes
     
103. TSIZE=$($GETVAL UndoDataBuffer)
     
104. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
     
105. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
     
106. print_size "UndoDataBuffer" $TSIZE
     
107. 
     
108. #Attributes
     
109. TSIZE=$($GETVAL RedoBuffer)
     
110. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
     
111. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
     
112. print_size "RedoBuffer" $TSIZE
     
113. 
     
114. #Attributes
     
115. TSIZE=$($GETVAL LongMessageBuffer)
     
116. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
     
117. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
     
118. print_size "LongMessageBuffer" $TSIZE
     
119. 
     
120. #Attributes
     
121. TSIZE=$($GETVAL DiskPageBufferMemory)
     
122. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
     
123. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
     
124. print_size "DiskPageBufferMemory" $TSIZE
     
125. 
     
126. #Attributes
     
127. TSIZE=$($GETVAL SharedGlobalMemory)
     
128. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
     
129. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
     
130. print_size "SharedGlobalMemory" $TSIZE
     
131. 
     
132. #Attributes
     
133. TSIZE=$($GETVAL BackupMemory)
     
134. MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)
     
135. TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)
     
136. print_size "BackupMemory" $TSIZE
     
137. 
     
138. MEMSIZE=$(echo "scale=2; $MEMSIZE/$gsize" | bc -l 2>/dev/null)
     
139. 
     
140. echo
     
141. echo  "******Total Memory size: ${MEMSIZE}GB******"

复制代码

kerlion

说明下，计算公式是飞龙无痕提供的

飞鸿无痕

不错啊，很实用的一个工具！

kerlion

呵呵，加精了！
晕，是飞鸿无痕，飞龙在天用多了

飞鸿无痕

回复 5# kerlion


    恭喜恭喜，哈哈！