How do I find out who is making a lot of requests to the server?

Question

I am running Apache server and would like to find out who (IP address) is making a lot of request for the last 24 hours using command line. Also like to find out who has the most open connection at the moment?

Answer 1

I am running Apache server and would like to find out who (IP address) is making a lot of request for the last 24 hours using command line.

awk '/29\/Sep\/2011/ { print $1 }' /path/to/access_log | sort | uniq -c | sort -rn | head

Also like to find out who has the most open connection at the moment?

netstat -natp | grep httpd | awk '{ print $5 }' | cut -d: -f1 | sort | uniq -c | sort -rn | head

Answer 2

You can use tail /path/to/apache_log_file (check in /var/log/apache2). One way to see current connections is to use mod_status. You can also use netstat -a |grep www