[Mod_log_sql] mod_log_sql + mysql + "Insert Delayed" == ????

Matt Pressnall loki_mdog at yahoo.com
Mon Feb 7 17:25:37 EST 2005

Hi there --

I have just got mod_log_sql up and running and am
about to do some stress tests on the install and
wanted to see what kind of difference delayed inserts
would make.

Looking at the current documentation:

I see you are supposed to "set LogSqlDelayedInserts On
in the httpd.conf"; however, when I do that, I get:

Invalid command 'LogSqlDelayedInserts', perhaps
mis-spelled or defined by a module not included in the
server configuration

So I did some looking around and see that
'LogSqlDelayedInserts' is deprecated and that I should
use LogSQLDBParam.

The only thing is I don't know what a parameters to
pass in to it.  I have tried:
LogSQLDBParam Insert Delayed
LogSQLDBParam DelayedInsert on

But I'm just guessing.

Next, I looked through the archived mailing list and I
saw some talk about getting "Insert Delayed" back into
mod_log_sql so I am wondering if it was taken out when
LogSQLDBParam rolled out.

So questions:

What is the status of "Insert Delayed" with

If it is working, what do you pass to LogSQLDBParam to
get it to work? 

I've looked everywhere and cannot find the right

Many, many thanks!

PS  AWESOME MODULE!  This thing rules!

Do you Yahoo!? 
Yahoo! Mail - 250MB free storage. Do more. Manage less. 

More information about the Mod_log_sql mailing list