系统监控
iostat -x -t 60 > /home//song/iostat.txt &
top -b -d 60 > /home//song/top.txt &
sar -n DEV 60 > /home/song/sar.txt &
sh /home/song/7_sys_locks.sh &
7_sys_locks.sh
while [ 1 -eq 1 ]
do
pgsql -U test_web -d grcoa -c "select * from sys_locks;" >> /home/song/sys_locks.txt
pgsql -U test_web -d grcoa -c "select count(*), state from pg_stat_activity group by state;" >> /home/song/connection.txt
pgssql -U test_web -d grcoa -c "select * from pg_stat_user_tables where n_tup_ins > 100;" >> /home/song/table_stat.txt
pgsql -U test_web -d grcoa -c "select * from pg_stat_user_indexes where idx_scan > 100;" >> /home/song/index_stat.txt
sleep 60
done
清空文件
:> XXX.log
> XXX.log
echo /dev/null > XXX.log
查看数据库大小
echo "data dir size:" >/home//song/task_log.log
du -sh /home/data >>/home/song/task_log.log
echo "grcoa database size:(MB)">>/home/song/task_log.log
pgsql -U test_web grcoa -e -c "select pg_database_size('grcoa')/1024/1024;">>/home/song/task_log.log
echo "table oa_send_doc_form size:">>/home/song/task_log.log
pgsql -U test_web grcoa -e -c "select count(*) from oa_send_doc_form;">>/home/song/task_log.log
#/bin/sh
iostat -x 60 -t > mn-io.log &
ssh -l root h104 iostat -x 60 -t > tn1-io.log &
ssh -l root h105 iostat -x 60 -t > tn2-io.log &
sar -n DEV 60 > mn-sar.log &
ssh -l root h104 sar -n DEV 60 > tn1-sar.log &
ssh -l root h105 sar -n DEV 60 > tn2-sar.log &
top -b -u kingbase -d 60 > mn-top.log &
ssh -l root h104 top -b -u kingbase -d 60 > tn1-top.log &
ssh -l root h105 top -b -u kingbase -d 60 > tn2-top.log &