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? > (I presume I can get the DB schema from it.) > > 2) Can MySQL handle a little more than one million records a day > (currently)? If so, what kind of disk space needs will it have? > > 3) Am I out of my mind? Anything I'm not considering, that I should?
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 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]