Input (MySQL status): | Com_select | 16653146213 | | Com_delete | 43654772 | | Com_insert | 637410971 | | Com_update | 673829655 | Output: Read Query # Write Query # Below script works, but I think there must be a concise AWK one. #!/bin/sh declare -i m n i j m=`awk '$2 == "Com_select" {print $4}' /var/log/mysql/status1` n=`awk '$2 == "Com_select" {print $4}' /var/log/mysql/status2` i=`awk '$2 == "Com_delete" || $2 == "Com_insert" || $2 == "Com_update" {sum += $4} END {print sum}' /var/log/mysql/status1` j=`awk '$2 == "Com_delete" || $2 == "Com_insert" || $2 == "Com_update" {sum += $4} END {print sum}' /var/log/mysql/status2` awk -v Read1=$m -v Read2=$n 'BEGIN { printf( "%.4f\n", (Read2 - Read1)/ 300 ) }' awk -v Write1=$i -v Write2=$j 'BEGIN { printf( "%.4f\n", (Write2 - Write1)/300 ) }'