[Mod_log_sql] Scripts for mod_log_sql

Edward Rudd urkle at outoforder.cc
Sat Oct 16 10:24:28 EST 2004


On Fri, 2004-10-15 at 16:04, Mike Hillyer wrote:
> 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/
> 
[snip]
> 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.
> 
This is awesome.. I haven't yet tested them, but they look good. The
only concern I have is about locking when selecting.. And how it would
effect the inserts going to the Database while the SQL script is
selecting..  This can probably be avoided by using InnoDB, (nneds
thorough testing still).  Or by me getting delayed inserts back into
mod_log_sql (it's on my TODO list this weekend).

> Hopefully the mod_log_sql community will find these of use.
Would you have any problem if I included this in the "contrib" directory
with the mod_log_sql distribtution?

> Regards,
> Mike Hillyer
> www.openwin.org/mike
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
> 
> To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe at lists.outoforder.cc
-- 
Edward Rudd <urkle at outoforder.cc>
Website http://www.outoforder.cc/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20041016/6f1d128f/attachment.bin 


More information about the Mod_log_sql mailing list