Re: [users@httpd] storing log data in a database

[Sean Davis <sdavis2@xxxxxxxxxxxx>]

Title: Re: [users@httpd] storing log data in a database

We store to a DB also.  I have a mod_perl handler that does that work.  If you have mod_perl running, you might google around a bit for mod_perl –based logging.  It is quite easy to do.  We log to a Postgres database, but since perl uses DBI, which is database independent (pretty much), you can really use any database you like.  The logging is then totally self-contained and can be customized in a single place.  

Sean


On 2/19/06 12:47, "Steve" <lardcanoe@xxxxxxxxx> wrote:

> Only bother doing it if you actually need to perform queries on the data. Basically any good log analyzer will work with regular log files, so there is no need to use a DB for that.
>
> We use the DB approach at my work because we have many web servers, and sending the logs to a DB allows us to see realtime website hits and track everything that is currently going on. The logs are sent to an intermediate script that sends to a local log file on the webserver, and then to the DB. 
>
> If you do go this route, and use MySQL, make sure the table can handle a size greater than 4GB. By default, it can't, and that hurt us when it happened...
>
> Enjoy!
>
> On 2/17/06, Khai Doan <khai_quyen@xxxxxxxxxxx> wrote:
> > Hi All,
> >
> > I am thinking about storing the log data in a database.  What do you think
> > about it?  Is it a good idea or bad idea?
> >
> > Thanks
> > Khai
> >
> >
> >
> > --------------------------------------------------------------------- 
> > The official User-To-User support forum of the Apache HTTP Server Project.
> > See <URL:http://httpd.apache.org/userslist.html> for more info.
> > To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
> >    "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx  <mailto:users-digest-unsubscribe@xxxxxxxxxxxxxxxx> 
> > For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx