tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: [OT] Thread Dump
Date Fri, 04 Jun 2010 17:12:25 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Peter,

On 6/4/2010 3:50 AM, Peter Crowther wrote:
> On 4 June 2010 06:08, suchismitasuchi <suchismitasuchi@rediffmail.com> wrote:
>>
>> Thanks a lot.
>> What will be the workaround for this?
> 
> Having said all of that, my guess is that either a) you're overloading
> your MySQL database with queries or b) you have code that causes a
> deadlock somewhere in the database.  In either case, I suggest
> monitoring MySQL.  If it's very busy, it's probably overloaded; if
> it's very quiet, you probably have a deadlock.

MySQL is pretty good at detecting deadlock and canceling queries to
allow one (or more) continue. They could just be queries that take
forever to run. "SELECT * FROM huge_table JOIN huge_table" is one sure
way to lock-up a query.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkwJM/kACgkQ9CaO5/Lv0PBXYgCgwWKJpiKg/zBxK2lHQwOLtKYc
n4UAoKqY6oC2/P4AE87gml3YaBLCkS1W
=iPtG
-----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