验证mysql集群_MySQL Cluster验证管理节点配置中内存是否超标的脚本

验证管理节点config.ini参数配置的shell脚本，看memory是否超标，运行的时候需要附带上面data node id，而且cluster要处于工作状态，最起码manage node和data node要处于启动状态

run check_memery.sh

脚本内容下：

# 注明，是从网友飞鸿大哥那里趴过来，改改运行通过的，肯定有很多需要完善的地方，欢迎大家提出宝贵的意见。

#!/bin/bash

usage()

{

echo "-----------------------------"

echo "Usage:$(basename $0) NodeId"  #数据节点的ID

echo "-----------------------------"

echo

exit 1

}

print_size ()

{

string1=$(echo $1|sed -e :a -e 's/^.\{1,40\}$/&./;ta')

echo -e "$string1 (MB):\t$2"

}

if [ "$1" == "" ]; then

usage

fi

string1=$(echo $1|egrep "^[0-9]+$")

if [ "$1" != "$string1" ]; then

usage

fi

# GETVAL="ndb_config  --id=$1 -q"

GETVAL="/root/MySQL-cluster-gpl-7.2.7-linux2.6-x86_64/bin/ndb_config  --id=$1 -q"

#ndb_config  --id=12 -q MaxNoOfAttributes

ksize=1024

msize=$(echo "scale=2; 1024*1024" | bc -l 2>/dev/null)

gsize=$(echo "scale=2; 1024*1024*1024" | bc -l 2>/dev/null)

echo "KB:$ksize MB:$msize GB:$gsize"

MEMSIZE=0

#Attributes

TSIZE=$($GETVAL MaxNoOfAttributes)

TSIZE=$(echo "scale=0; $TSIZE*200" | bc -l 2>/dev/null)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "MaxNoOfAttributes" $TSIZE

#Attributes

TSIZE=$($GETVAL MaxNoOfTables)

TSIZE=$(echo "scale=0; $TSIZE*20*$ksize" | bc -l 2>/dev/null)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "MaxNoOfTables" $TSIZE

#Attributes

TSIZE=$($GETVAL MaxNoOfOrderedIndexes)

TSIZE=$(echo "scale=0; $TSIZE*10*$ksize" | bc -l 2>/dev/null)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "MaxNoOfOrderedIndexes" $TSIZE

#Attributes

TSIZE=$($GETVAL MaxNoOfUniqueHashIndexes)

TSIZE=$(echo "scale=0; $TSIZE*10*$ksize" | bc -l 2>/dev/null)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "MaxNoOfUniqueHashIndexes" $TSIZE

#Attributes

TSIZE=$($GETVAL MaxNoOfConcurrentOperations)

TSIZE=$(echo "scale=0; $TSIZE*1*$ksize" | bc -l 2>/dev/null)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "MaxNoOfConcurrentOperations" $TSIZE

#Attributes

TSIZE=$($GETVAL TransactionBufferMemory)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "TransactionBufferMemory" $TSIZE

#Attributes

TSIZE=$($GETVAL IndexMemory)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "IndexMemory" $TSIZE

#Attributes

TSIZE=$($GETVAL DataMemory)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "DataMemory" $TSIZE

#Attributes

TSIZE=$($GETVAL UndoIndexBuffer)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "UndoIndexBuffer" $TSIZE

#Attributes

TSIZE=$($GETVAL UndoDataBuffer)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "UndoDataBuffer" $TSIZE

#Attributes

TSIZE=$($GETVAL RedoBuffer)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "RedoBuffer" $TSIZE

#Attributes

TSIZE=$($GETVAL LongMessageBuffer)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "LongMessageBuffer" $TSIZE

#Attributes

TSIZE=$($GETVAL DiskPageBufferMemory)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "DiskPageBufferMemory" $TSIZE

#Attributes

TSIZE=$($GETVAL SharedGlobalMemory)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "SharedGlobalMemory" $TSIZE

#Attributes

TSIZE=$($GETVAL BackupMemory)

MEMSIZE=$(echo "scale=2; $MEMSIZE+$TSIZE" | bc -l 2>/dev/null)

TSIZE=$(echo "scale=0; $TSIZE/$msize" | bc -l 2>/dev/null)

print_size "BackupMemory" $TSIZE

MEMSIZE=$(echo "scale=2; $MEMSIZE/$gsize" | bc -l 2>/dev/null)

echo

echo  "******Total Memory size: ${MEMSIZE}GB******"

MySQL Cluster 的详细介绍：请点这里

MySQL Cluster 的下载地址：请点这里

推荐阅读：