#!/bin/sh

#mysql password for root
mysql_password=''
#where mysql and mysqladmin is located
mysql_bin_dir=/usr/local/mysql/bin

info=`${mysql_bin_dir}/mysqladmin -u root -p${mysql_password} status |awk '{print $2 " " $6}'`
queries=`echo $info|awk '{print $2}'`
uptime=`echo $info|awk '{print $1}'`
uptime=`echo "select sec_to_time($uptime);"|${mysql_bin_dir}/mysql -p${mysql_password} --skip-column-names`
echo $queries
echo $queries
echo $uptime


