?
Solved

How to extract concurrent users checking access_log file

Posted on 2004-08-05
8
Medium Priority
?
335 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

If you are running a LAMP infrastructure, this little code snippet is very helpful if you are serving lots of HTML, JavaScript and CSS-related information. The mod_deflate module, which is part of the Apache 2.2 application, provides the DEFLATE…
If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 2 hours left to enroll

764 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