Re: Storing Apache logs in MySQL.

2007-11-11 Thread Filip Krejci
This however is not an option at all when you run Apache in prefork mode. Because the sum of your MaxClients will be equal to the connections to your MySQL Server. You can use connection pooling eg SQLrelay -- Filip Krejci <[EMAIL PROTECTED]> Linux - und Spass dabei! -- MySQL General Ma

Re: Storing Apache logs in MySQL.

2007-11-09 Thread Samuel Vogel
Hi, An easier method may be to install mod_log_mysql on each of the Apache servers and log directly to the central MySQL installation. Regards Ian This however is not an option at all when you run Apache in prefork mode. Because the sum of your MaxClients will be equal to the connectio

Re: Storing Apache logs in MySQL.

2007-11-09 Thread Ian
On 9 Nov 2007 at 10:44, Shaun T. Erickson wrote: > I pull Apache (combined format) logs, daily, from a number of mirrors, > back to a central server for processing. I'd like to somehow load them > in MySQL for analysis. > > 1) Does anyone know of a script that can parse the logs and load them? >

Storing Apache logs in MySQL.

2007-11-09 Thread Shaun T. Erickson
I pull Apache (combined format) logs, daily, from a number of mirrors, back to a central server for processing. I'd like to somehow load them in MySQL for analysis. 1) Does anyone know of a script that can parse the logs and load them? (I presume I can get the DB schema from it.) 2) Can MySQL han