Re: traffic analysis

> However, I think the idea of performing live analysys against MySQL's
> data a *very* good one.  It would eliminate the whole process of log
> extraction, and would provide realtime status of the weblogs.

However, it's always better to merge as much data as possible and write a
summary of days, weeks, months to a different table, rather than calculating
everything all the time.

Regarding insert_access_log.pl... script is very cpu consuming and very very
slow (tested on multi-cpu Xeon 2.4 box).

I'm still waiting for a mod_log_sql_apache2 :(

Regards,
Miha Rozic

----- Original Message ----- 
From: "Chris Powell" <[email protected]>
To: <[email protected]>
Sent: 7. oktober 2003 17:49
Subject: Re: [mod_log_sql] traffic analysis


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Shane Chrisp wrote:
> > Im sure that this type of product would be of great value to many
people.
> > The included perl script that is included with mod_log_sql is handy for
> > those who want to get going in a hurry, but some don't have the
resources
> > to implement other scenario's.
>
> Yes, the intent all along was to have MySQL be the log 'repository,' but
> to have analysis of said logs take place out of the database, via a
> temporary file mimicing the format of the Apache combined log.  Hence
> the make_combined_log.pl script.
>
> However, I think the idea of performing live analysys against MySQL's
> data a *very* good one.  It would eliminate the whole process of log
> extraction, and would provide realtime status of the weblogs.
>
> Regards,
> Chris
> - --
> Chris Powell
> [email protected]
> (206) 783-5104 voice, (815) 461-4456 fax
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.2 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQE/guCjYLVoao8MjQkRArHIAJ4jZa4592Z9pnNT6gOoKyslwqwmPQCdEFBp
> FwyrB4bc5WXAJsC1gptNCPQ=
> =6NAl
> -----END PGP SIGNATURE-----
>
> ____________________________________________________________________
> Reminder: to unsubscribe, send email to <[email protected]>
> with the words "unsubscribe mod_log_sql" in the body (w/o quotes).
> The module homepage is http://www.grubbybaby.com/mod_log_sql/
> The list archives are here:
> http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql
>

____________________________________________________________________
Reminder: to unsubscribe, send email to <[email protected]>
with the words "unsubscribe mod_log_sql" in the body (w/o quotes).
The module homepage is http://www.grubbybaby.com/mod_log_sql/
The list archives are here:
http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql