I have a website hosting a lot of Document files (PDF, XLS, ETC). I frequently get requests for a tally of downloads per month for specific files. Historically, I've just used sed,awk and brethren to grep the apache logs for the desired filename along with entries containing 'GET' and a 200 status code then piping the whole thing to wc.
People are now wanting historical tallies going back through years of logs. Combing through log files takes a lot of time and resources. I'm wondering if there is an apache mod or something similar which will log those GET requests to a database?