Calculating the queries per second average in Mysql

By jon On May 30, 2007 · 1 Comment

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.

These icons link to social bookmarking sites where readers can share and discover new web pages.