page requests

[seby]

i had made a script sometime ago that shows how many pages are being requested over the last xx minutes.

unfortunately the only way i thought i could make this would be to use mysql.. by inserting a record into the database every time a page was loaded.

then i had to make two other queries, one to count the rows to display the current number of page requests, and another to delete older rows that were over xx minutes.

this all requires three mysql queries, unfortunately my site has grown quite a bit since and creating 3 extra queries everytime someone loaded a page was becoming a problem.

so... i'm wondering if there is any other method to determine the amount of pages being served up over xx minutes?

does apache keep track of any of this, just looking for ideas how i can do this since i want to keep track of this, but at the sametime not perform 3 queries 🙁

thanx for any ideas.

[seby]

also, i had thought of this:

insert the unix timestamp in a file every time a page is requested, then count the lines in the file.

.. but how could i remove the timestamp on lines over xx minutes?

would this be faster than running 3 queries as in my post above?

[dnszero]

Apache stores this info in the log files. Check your apache config file to find out exactly where. They should be pretty easy to parse with a script. If the answer isn't clear after looking at the logs, you might search around as the number of log parser seems to be growing everyday, especially if you're just interested and don't need the value in a dynamic php script. Webalizer is a nice one to have handy, regardless.