MySQL Cluster验证管理节点配置中内存是否超标的脚

页面导航:首页 > 数据库 > Mysql > MySQL Cluster验证管理节点配置中内存是否超标的脚

MySQL Cluster验证管理节点配置中内存是否超标的脚

来源: 作者: 时间:2016-02-17 10:07 【

MySQL Cluster验证管理节点配置中内存是否超标的脚本验证管理节点config.ini参数配置的shell脚本,看memory是否超标,运行的时候需要附带上面data node id,而且cluster要处于工作状态,最起码
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/-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******"

 

 
 
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<