[MYSQL] 상태 확인

[시스템 정보 확인] 

#echo "";echo "[DATE]";date;echo "";echo "[HOSTNAME]";hostname;echo "";echo "[UPTIME]";uptime;echo "";echo "[FS]";df -h;echo "";echo "[MEMORY]";free -m;echo "";

[SQL Node Process 확인] 

#ps -ef | grep mysqld | grep -v grep 

[MySQL Variables 확인] 

#/usr/local/mysql/bin/mysql -uroot -p -e "show global variables;"

[MySQL Status 확인] 

#/usr/local/mysql/bin/mysql -uroot -p -e "show global status;"

[DB의 Table 당 DATA 크기와 INDEX 크기 확인] 

#/usr/local/mysql/bin/mysql -uroot -p -e "select table_schema,table_name,(data_length)/(1024*1024) as 'DATA(MB)',(index_length)/(1024*1024) as 'INDEX(MB)' from information_schema.tables ;"

[SQL Node 로그 확인] 

#tail -100 /data/mysqldb/datadb/sql2.err

[MGM Node Process 확인] 

#ps -ef | grep ndb_mgmd | grep -v grep

[Cluster 상태 확인]

#/usr/local/mysql/bin/ndb_mgm -e "show"

[Cluster 메모리 사용량 확인]

#/usr/local/mysql/bin/ndb_mgm -e "all dump 1000"; tail -10 /mysqldb/clusterdb/ndb_1_cluster.log | grep -w usage

[MGM Node 로그 확인] 

#/mysqldb/clusterdb/ndb_1_cluster.log


[각 시스템 상태 확인] 

#vmstat -S m -n 5 60

[DATA Node Process 확인] 

#ps -ef | grep ndbd | grep -v grep

[DATA Node 로그 확인] 

#tail -20 /data/mysqldb/clusterdb/ndb_3_out.log

#tail -20 /data/mysqldb/clusterdb/ndb_3_error.log


[점검후 최종 상태 확인]

#/usr/local/mysql/bin/ndb_mgm -e "show"