Rusty Razor Blade

Calculating the queries per second average in Mysql

I didn’t find any simple ways to determine how hard our mysql database was working, so I whipped this up. It uses a 10 second delay to figure out the queries per second average.


time=10
orig=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'`
sleep $time
last=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'`
diff=`expr $last - $orig`
avg=`expr $diff / $time`
echo "$avg"


Save the above to a text file in your ~/bin directory, or wherever you exec shell scripts from.