#!/bin/sh
username=root
passwd=aaa
host=10.111.1.1
date=`date +%Y%m%d`
log_dir=/data/process_list/
n=`mysqladmin processlist -u$username -p$passwd -h$host| wc -l`
date_time=`date +%Y%m%d[%H:%M:%S]`
echo "-----------------------------------------------------------------------------" >>$log_dir$date.log
echo "Time:"$date_time >>$log_dir$date.log
echo "连接数:"$n >>$log_dir$date.log
if [ "$n" -gt 10 ];then
IFS=$'n' #
for line in `mysqladmin processlist -u$username -p$passwd -h$host`
do
echo $line >>$log_dir$date.log
done
fi