I am following this
And parsing the logs to get the stats of applications is hard if theres heavy traffic its hard to get everything to parse right.
Would it be easier to import all the stats into mysql db once an hour that way its easier to work with?
Since you are looking at parsing the access logs, you can do it using a regular expression as the logs are in proper Tab separated fromat . If you plan to query and move everything to Database make sure you do incremental parsing. However, you may keep everything in the log only and parse using Regex (using awk, sed or perl) as and when required.