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

[Steve <lardcanoe@xxxxxxxxx>]

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
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx