数据库连接查询

查询mongo数据库连接情况

 netstat -antp|grep -i 27017 | awk '{print $5}'| cut -d: -f1 | sort | uniq -c | sort -n

查询mysql数据库连接情况

select SUBSTRING_INDEX(host,':',1) as datables , count(*) from information_schema.processlist group by datables;
select DB , count(*) from information_schema.processlist group by DB;

查询redis数据库连接情况

 netstat -an|grep 6379 | grep 172.10.0.44 | wc -l