Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: average transaction time
Top Forums Shell Programming and Scripting average transaction time Post 302116164 by nhatch on Wednesday 2nd of May 2007 06:42:44 AM
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:
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT X11R4

nislog

nislog(1M)						  System Administration Commands						nislog(1M)

NAME

       nislog - display the contents of the NIS+ transaction log

SYNOPSIS

       /usr/sbin/nislog [-h num | -t num]  [-v] [directory...]

DESCRIPTION

       nislog  displays  the  contents of the NIS+ server transaction log on the standard output. This command can be used to track changes in the
       namespace. The /var/nis/trans.log file contains the transaction log maintained by the NIS+ server. When updates occur, they are	logged	to
       this  file  and	then  propagated  to replicas as log transactions.  When the log is checkpointed, updates that have been propagated to the
       replicas are removed.

       The nislog command can only be run on an NIS+ server by superuser. It displays the log entries for that server only.

       If directory is not specified, the entire log is searched. Otherwise, only those logs entries that correspond to the specified  directories
       are displayed.

OPTIONS

       -h num	       Display num transactions from the ``head'' of the log. If the numeric parameter is  0, only the log header is displayed.

       -t num	       Display	num transactions from the ``tail'' of the log. If the numeric parameter is  0, only the log header is displayed.

       -v	       Verbose mode.

FILES

       /var/nis/trans.log      transaction log

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWnisu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       nis+(1), rpc.nisd(1M), nisfiles(4), attributes(5)

NOTES

       NIS+  might  not  be  supported in future releases of the SolarisTM Operating Environment. Tools to aid the migration from NIS+ to LDAP are
       available in the Solaris 9 operating environment. For more information, visit http://www.sun.com/directory/nisplus/transition.html.

SunOS 5.10							    12 Dec 2001 							nislog(1M)
All times are GMT -4. The time now is 10:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy