I'm looking to see what the "hot" pages are on one of my sites. I want to see for various timeframes, what the top-50 pages are. I'm only concerned with the current month's data.
I'm going to create a data feed with this info which will be input to another app. I have Apache logs, and complete control of the machine to install what I want. I'm mostly wondering if there's something out there already that I can use, or if I have to implement it myself, what good algorithms or strategies might be.
NOW()
andDATE_SUB(NOW(), INTERVAL 6 WEEKS)
.mod_log_mysql
orlogtomysql
to be enabled in the config file.