[Mod_log_sql] mod_log_sql and threaded apache2

[Edward Rudd]

Daniel Mayer [COUGA.net] wrote:
[snip]
> 
> My question therefore is if mod_log_sql should work with the threaded
> model or not at all. I tried the newest source code as well as some
> older ones and the precompiled apache packages.
> 

Currently mod_log_sql does not work under threaded mode. What happens is
there is only one MySQL connection PER process so with the worker MPM
there is only ONE MySQL connection total and things can and WILL get
bottlenecked.  Also I believe by default mod_log_sql links with the
standard mysql client package.  You can try changing the resulting
Makefile to link against mysqlclient_r instead of mysqlclient and see if
that alleviates the segfaults.  However, at this time I would not
recommend running mod_log_sql under a threaded environment.. I WILL be
changing this in the future as I will be switching the database layer to
apr_dbd which support connection pooling and full theading for use under
apache 2.2.

Edward Rudd <urkle at outoforder.cc>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 251 bytes
Desc: OpenPGP digital signature
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20061218/3b2244d0/attachment.bin