[Mod_log_sql] Scripts for mod_log_sql
Mike Hillyer
mike at openwin.org
Fri Oct 15 16:04:33 EST 2004
Hi All;
For those who are interested I have posted a pair of scripts at
http://www.openwin.org/mike/index.php/archives/2004/10/working-with-mod_log_sql/
These two scripts enable you to load existing Apache logs into MySQL,
and also return a mod_log_sql table as a CLF formatted text file.
While there are existing perl scripts in the contrib folder of
mod_log_sql, these scripts are pure SQL, and do not require perl or any
other external language. All work is accomplished through LOAD DATA and
SELECT ... INTO OUTFILE queries.
LOAD DATA and SELECT ... INTO OUTFILE can often be much more efficient
than loading files using external tools, and so I am sure you will find
these scripts to be quite efficient. I was able to unload a 10 million
row table to a CLF file in about 4 minutes on a desktop system.
Hopefully the mod_log_sql community will find these of use.
Regards,
Mike Hillyer
www.openwin.org/mike
More information about the Mod_log_sql
mailing list