average transaction time


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting average transaction time
# 1  
Old 05-02-2007
average transaction time

Hi all,

I have large daily log file(s) that hold the times for requests and responses on different system requests. What I want to do is work out average transaction times for the day (one log = one day).

The problem I'm having is figuring out how to skip rows, i've sorted the output by uniq trans id and then worked out the time taken but then skipping to the next uniq trans id (two lines down) is proving difficult, any sugestions?

The below is the example of the extracted lines.

Date/TIME, Trans, Link name, uniq trans id, trans status

20070422095251 REQUEST - LINK_2:<437288668/1>:
20070422095251 RESPONSE - LINK_2:<437288668/1>:0:
20070422095251 REQUEST - LINK_2:<437288672/1>:
20070422095251 RESPONSE - LINK_2:<437288672/1>:0:
20070422095251 REQUEST - LINK_2:<437288699/1>:
20070422095252 RESPONSE - LINK_2:<437288699/1>:0:
20070422095252 REQUEST - LINK_2:<437288698/1>:
20070422095252 RESPONSE - LINK_2:<437288698/1>:0:
20070422095252 REQUEST - LINK_2:<437288730/1>:
20070422095253 RESPONSE - LINK_2:<437288730/1>:0:
20070422095253 REQUEST - LINK_2:<437288750/1>:
20070422095253 RESPONSE - LINK_2:<437288750/1>:0:
# 2  
Old 05-02-2007
what output

Could you tell us what output do you want from the listing given?
# 3  
Old 05-02-2007
Hi,

All I plan is to display is the number of transactions per second or seconds per tranasction (which ever I decide).

From the log I cut out the time and trans id field and that will produce a file sorted by transaction id number.

I then want to go through and work out the time taken for each tranasaction, the problem is I don't know how to transend the file and work out the time for each transaction. Should I do a while read statement? I'm not sure.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Difference between BEGIN TRANSACTION & START TRANSACTION?

What's the difference between BEGIN TRANSACTION vs START TRANSACTION? Also goes for COMMIT TRANSACTION vs COMMIT? (0 Replies)
Discussion started by: dan139
0 Replies

2. Shell Programming and Scripting

Need to get average idle time using mpstat

I want to get average idle time of the server using mpstat. The problem I am having is %idle is not in same columns in all the versions of linux. example 1: example 2: I tried below command as generalized solution but as Average as one less column output is not proper. I am... (1 Reply)
Discussion started by: kumarjohn
1 Replies

3. Shell Programming and Scripting

Calculate Average time of one column

Hello dears, I have a log file with records like below and want to get a average of one column based on the search of one specific keyword. 2015-02-07 08:15:28 10.102.51.100 10.112.55.101 "kevin.c" POST ... (2 Replies)
Discussion started by: Newman
2 Replies

4. Shell Programming and Scripting

Append transaction header lines to same transaction's detail lines

Hi guys, I was wondering if someone can give me a hand in helping me append transaction header line in a file at the end of the transaction detail lines. Basically, I have a file that looks like this: FHEAD File1 THEAD TRANS1-blah TDETL HI1 TDETL HI2 TDETL HI3 TTAIL TRANS1-blah THEAD... (3 Replies)
Discussion started by: rookie12
3 Replies

5. Shell Programming and Scripting

Calculate average time using a script

Hello, I'm hoping to get some help on calculating an average time from a list of times (hour:minute:second). Here's what my list looks like right now, it will grow (I can get the full date or change the formatting of this as well): 07:55:31 09:42:00 08:09:02 09:15:23 09:27:45 09:49:26... (4 Replies)
Discussion started by: jaredhanks
4 Replies

6. Shell Programming and Scripting

bash script to count the time of transaction

Halo, Bash Script can get the time of process the trasaction or not? For example, bash script use to procee the trasaction, like select and checking.. then generate the XML. after it, i need to get the time which to count the process. Anyone can help me? Thank you (1 Reply)
Discussion started by: ryanW
1 Replies

7. Shell Programming and Scripting

Perl or Shell script to read a transaction log in real time

Hello, I have a Apache webserver running on RedHat. Its primary function is a proxy server for users accessing the internet. I have a transaction log that logs every transactions of every users. For users trying to access certain sites/content the transactions goes into a 302 redirect loop and... (2 Replies)
Discussion started by: bruno406
2 Replies

8. UNIX for Dummies Questions & Answers

Average in awk based on time

Hi I am looking for an awk script which can compute the average of the last column based on the date and time. The file looks: site1,"2000-01-01 00:00:00", "2000-01-01 00:59:00",0.013 site2,"2000-02-01 01:00:00", "2000-02-01 01:59:00",0.035 site1,"2000-02-01 02:00:00", "2000-02-01... (15 Replies)
Discussion started by: kathy wang
15 Replies

9. UNIX for Dummies Questions & Answers

Average completion time calculation?

I've been trying all night to come up with a script that will take a file that contains job completion times like this as input: 18:30 17:45 16:39 18:01 17:50 ... and figure the Average completion time. I've tried several things, and I just can't seem to get it to figure correctly. I'm... (5 Replies)
Discussion started by: Seawall
5 Replies

10. UNIX for Dummies Questions & Answers

Average Time

Hi Guys, I am using a command $ runprt_req PPGUS_ROYXN1102 Output: **************** Start Date and Time End Date and Time*** PPGUS_ROYXN1102 01/15/2008 02:20:08 01/15/2008 04:54:50 PPGUS_ROYXN1102 01/12/2008 02:03:57 01/12/2008 04:22:10... (1 Reply)
Discussion started by: sambond
1 Replies
Login or Register to Ask a Question