[Mod_log_sql] microseconds patch

[Shawn Michael]

Attached is a patch against 1.99 to add support for the microseconds duration 
option present in apache 2.0.  The patch does apply cleanly to 1.100 so it should 
be easily tested against that version.

It alters the schema a bit and adds the log format option "D" which corresponds 
to the apache 2.0 microseconds log format string.  It should be noted that it 
looks to be either or for logging time.  Either microseconds or whole seconds can 
be logged.  The new column name is request_duration_ms and should be a relatively 
large number.

Since I also got the whole milli vs micro confused in my head... To get the 
number of seconds divide the number in the request_duration_ms column by 
1,000,000 and tada -- Seconds ;)

As a side note we have been doing numerous tests with apache to try to determine 
exactly what apache records for it's time fields.  Apache records the time from 
start of transaction until it can write the last byte to the network buffers.  If 
you want to "cheat" a little you can improve your reported performance stats by 
adding:
	SendBufferSize 131071

to the main section of your httpd.conf file.  The default buffer size is 16k and 
increasing it to 128k will help your stats out considerably.  Most pages fit into 
this buffer size so apache will report what it took to get the page out and 
doesn't count the slow connection speed of the client.

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Shawn Michael                                   smichael at rightnow.com
RightNow Technologies                           Hosting Administrator
                                  A Better Way to Serve your Customers
-------------- next part --------------
A non-text attachment was scrubbed...
Name: microseconds.patch
Type: text/x-patch
Size: 3671 bytes
Desc: not available
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20050125/21185eee/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3202 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20050125/21185eee/attachment-0001.bin