#!/bin/bash
cd  $(dirname $0)
ip=1.1.1.1
db_user=cc_rw
db_passwd=111111
sql=" show full processlist"
start_time=$(date +%s)
let "check_time=start_time+60";
now=$start_time

while [ $now -lt $check_time ];
do
	log_dir=./data/$(date +"%Y-%m-%d")/$(date +"%H")/$(date +"%M")
	mkdir -p $log_dir	
	log_file=$log_dir/$(date +"%Y-%m-%d-%H-%M-%S")
	echo $sql | mysql  -u${db_user} -p${db_passwd} -h${ip} online  > $log_file.www
	echo "next "
	sleep 10;
	now=$(date +%s)
done