Solved

How to extract concurrent users checking access_log file

Posted on 2004-08-05
8
331 Views
Last Modified: 2012-06-27
I was wondering, how can I  find out how many concurrent users are accesing my webserver?
I've been checking around some log analyzers, but even the better ones dont give me thi stats. Any advice?
Thanks.
0
Comment
Question by:gmartelli
  • 4
  • 4
8 Comments
 
LVL 51

Expert Comment

by:ahoffmann
ID: 11729644
> .. how many concurrent users ..
how do you define a "user"?
i.g. this is impossible, or in paricular: there is no 99.999% reliable method to do it.
0
 

Author Comment

by:gmartelli
ID: 11729664
Ok, how many Different IP addresses would do :).
Lets say, which is the top distincts IPs in a 1 minute period.
The point is, I need to figure out a concurrence, ANY measure of concurrence will help...and I only have the access log file to do it.
0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 11729865
awk '($5~/GET$/){print $3" "$4}' /var/log/httpd/access_log | awk -F: '($1=="16"&&$2=="15"){print}'

# replace 16 by your hour, and 15 by your minute
# to be improved in many ways (and adapted to you logfile format
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:gmartelli
ID: 11729892
Hum, how about in ANY minute? I mean, I want to find the top one, if I knew it, It would be quite easy to find out the total count of users in it :)
0
 
LVL 51

Accepted Solution

by:
ahoffmann earned 500 total points
ID: 11730205
what is "ANY" minute? 1 or 17 or 42 or ..
or do you mean somthing like:
 awk '($5~/GET$/){print $3" :"$4}' /var/log/httpd/access_log | awk -F: '{print $1":"$2" "$NF}'|sort -u
0
 

Author Comment

by:gmartelli
ID: 11730221
You get the points, I realized  getting into the realm of analytical SQL (which is what I'm checking now). I meant "the most user accesses in any given minute", meaning I dont know which minute i'm checking, its like a window aggregate (yah, deep magic but seems like Oracle will make things a bit easier for me :)


Thanks
0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 11730451
Oracle? hmm, sounds like breaking a fly on the wheel ;-)
Anyway, thanks for grading, hope it helps you anyway
KISS - keep it stupid simple
0
 

Author Comment

by:gmartelli
ID: 11730603
The problem is not the answer, but the question :)
Thanks for the help
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to boost certain documents at query time in Solr. Query time boosting can be a powerful resource for finding the most relevant and "best" content. Of course the more information you index, the more fields you will be able to use for y…
In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question