"Figuring out where your hits are coming from and which pages are being viewed is not too difficult if you use a good log analyzer like Analog or something similar.

But if you want to pull up reports on the fly at any time, you need to take a different route."

"For about six months, I was importing my Apache logs into an SQL database and then running ad-hoc queries against that.

Unfortunately, that requires me to go out and manually grab those log files, tweak the format a bit, then import. I wanted something better - something that was continually updated, gave me information on what content was being viewed, browser and platforms stats, and trends over time."

Complete Story

Related Stories:
Apache Guide: Logging, Part 5: Advanced Logging Techniques and Tips(Sep 25, 2000)
Apache Guide: Logging with Apache--Understanding Your access_log(Aug 21, 2000)