Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Awk > AWK Optimizatio...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 2172 of 2234
Post > Topic >>

AWK Optimization

by dnlchen@[EMAIL PROTECTED] Feb 27, 2008 at 04:44 PM

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 ) }'




 5 Posts in Topic:
AWK Optimization
dnlchen@[EMAIL PROTECTED]  2008-02-27 16:44:33 
Re: AWK Optimization
Janis <janis_papanagno  2008-02-28 01:49:37 
Re: AWK Optimization
Ed Morton <morton@[EMA  2008-02-28 06:43:38 
Re: AWK Optimization
dnlchen@[EMAIL PROTECTED]  2008-02-28 18:18:33 
Re: AWK Optimization
dnlchen@[EMAIL PROTECTED]  2008-02-28 18:22:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun May 11 18:20:46 CDT 2008.