up vote 1 down vote favorite
share [g+] share [fb]

We've somehow managed to accumulate over 50GB of IIS logs in a MySQL DB running on a linux server. We'd like to try and make some sense of the data. Are there any free & open-source software packages that can be tied directly to the MySQL DB to pull out statistics & other information?

link|improve this question
33% accept rate
feedback

3 Answers

up vote 0 down vote

check

http://awstats.sourceforge.net/

it is web based, but is very powerful, will be amazed by results

link|improve this answer
But can't be tied to the MSSQL database AFAIK – Mark Henderson♦ Nov 1 '10 at 1:07
you can export it to ASCII file, the program needs to pass it only one time to analyze it – jet Nov 2 '10 at 3:17
The OP is, apparently, using MySQL to store the logs. – Stephane Jan 11 '11 at 9:35
feedback
up vote 0 down vote

I usually use logparser for parsing my IIS logs (and all kind of logs). It doesn't do the pretty reports of awstats or other report-generators, but since it use a SQL-like query string, you can use it to extract data much more easily. Consider these tools as complementary to each other.

link|improve this answer
feedback
up vote -1 down vote

I generally use MS Access as a front end for MySQL. Access has pretty good reporting capabilities and chances are you already have it on at least one machine. Not FOSS but if you already have a copy it's no extra cost.

link|improve this answer
MS access, 50GB of data: out of bound error. – Stephane Jan 11 '11 at 9:34
@Stephane, the error has nothing to do with the amount of data. It's telling you the value in one of the fields is outside the allowable range. i.e. User error. Check your Access field definitions. – John Gardeniers Jan 11 '11 at 20:33
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.