Is there any way to show the most requested URL from apache over a timeframe, e.g. the most requested URL over the past 2 hours.
Is this type of thing possible with mod_status or could I aggregate the access logs?
Did you try awstat? It is log file analyzer tool. I am not sure if it can provide you with the stats within two hours as you requested.
You can also use a command like this to see the visited pages and its count within your log file.
The timeframe will depend on the contents of the log file. You can combine this with other commands like