Re: mod_log_sql and threaded apache2

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--===============1599461780==
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigA7C7615408EC2335B4515EE3"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigA7C7615408EC2335B4515EE3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Daniel Mayer [COUGA.net] wrote:
[snip]
>=20
> 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.
>=20

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 <[email protected]>


--------------enigA7C7615408EC2335B4515EE3
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFFhqjkvwMxRUUct20RAp9mAJ9AyY+UZWk20ffLLQAexCWeDoRQWgCfcfbb
D6LHWYzaoUCbIKMRhz/zNQA=
=kdcW
-----END PGP SIGNATURE-----

--------------enigA7C7615408EC2335B4515EE3--

--===============1599461780==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
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

--===============1599461780==--