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 / $timeecho "$avg"
Save the above to a text file in your ~/bin directory, or wherever you exec shell scripts from.