tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Tomcat 5.5.26 running 'select_user' for every transaction
Date Wed, 02 Nov 2011 16:00:31 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

David,

On 11/2/11 11:30 AM, David Kirtland wrote:
> Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny
> - apt versions) we are seeing a 'select_user' query to the database
> for every single transaction. This is in addition to a 'select 1'
> (the configured validationQuery). Obviously this is a big overhead
> which I don't see that we need.
> 
> If anyone can shed some light on what this is doing and why it's
> there (and ideally if we can turn it off) that would be very
> helpful! I've searched through the docs and can't really find any
> reference to it.

Have you tried:

$ grep -i "select_user" `find src -type f`

??

Tomcat itself is definitely not doing this to you.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6xaR8ACgkQ9CaO5/Lv0PBiuwCghQSFbfaAC19+1Pbd4GB5v0u9
5m8AoLsSM2qS7R54Ebx7scZGZGyqoWrv
=oFoL
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message