Re: Scripts for mod_log_sql

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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
-- 
Edward Rudd <[email protected]>
Website http://www.outoforder.cc/

_______________________________________________
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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBBcT0svwMxRUUct20RAhUKAJ0a2ef0fpoxJxps+g7rdGGJ0Xu1DACcDWx/
gDcs8t8MbZ02TXJPbIxo6D0=
=+hBI
-----END PGP SIGNATURE-----