监控:
连接数:
echo "db.serverStatus().connections"| mongo --port 40001 -u admin -p 'AdminPass123' --authenticationDatabase admin| grep current| cut -d ":" -f 3|cut -d "," -f 1 |cut -d " " -f 2
物理内存:
echo "db.serverStatus().mem"| mongo --port 40001 -u admin -p 'AdminPass123' --authenticationDatabase admin|grep resident | cut -d ":" -f 2 |cut -d "," -f 1| cut -d " " -f 2
虚拟内存:
echo "db.serverStatus().mem"| mongo --port 40001 -u admin -p 'AdminPass123' --authenticationDatabase admin|grep virtual | cut -d ":" -f 2 |cut -d "," -f 1| cut -d " " -f 2
页面错误
echo "db.serverStatus().extra_info.page_faults" |mongo --port 40001 -u admin -p 'AdminPass123' --authenticationDatabase admin|sed -n 3p
慢查询个数:
grep -i "ms" /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log >/opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log-1
mlogfilter /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log-1 --slow 3000 |wc -l >/tmp/slow-3s.log
日志告警
grep -i " exception: " /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log |wc -l >/tmp/mongo_err.log
grep -i " error " /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log >/opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log-1
grep -i " MongoError " /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log
grep -i " MongoException " /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log
grep -i " exception: " /opt/mongodb/log/`/bin/date -d yesterday +%Y-%m-%d`.log
MongoException
exception
more /opt/mongodb/mongodb_log.sh
#!/bin/bash
PATH="/opt/mongodb/log"
DATE=`/bin/date -d yesterday +%Y-%m-%d`
cd $PATH
if [ $PATH = `pwd` ]
then
echo "yes"
/bin/cat $PATH/mongodb.log |/bin/grep -v 'killcursors:' >> $PATH/$DATE\.log
#> $PATH/mongodb.log
else
exit 0
fi