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"
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.
Related Posts
Need Expert Help with Apache Cassandra?
Get professional consulting for your distributed systems challenges. Performance optimization, architecture design, and troubleshooting.