Re: MySQL Server crashes - spawning too many threads.
I just got mytop -- yippeee!
But the first thing I notice (I haven't dug too deeply into all that mytop can do yet) is that most of my threads are sleeping and some of them have been sleeping for like 400-600 seconds. I thought wait_timeout set to 15 seconds would stop this? the interactive_timeout is also set lowish (100) and connect_timeout is 10. What's up with this?
Supposedly we aren't using pconnect() but rather connect() ...
Ideas? suggestions?
thanks
erin
Subject
Views
Written By
Posted
3358
July 28, 2005 01:24PM
Re: MySQL Server crashes - spawning too many threads.
2120
July 28, 2005 03:27PM
2043
July 28, 2005 04:02PM
2444
July 28, 2005 05:50PM
1990
July 28, 2005 06:50PM
2015
July 28, 2005 07:37PM
2528
July 30, 2005 11:36AM
1875
August 01, 2005 01:54PM
2813
August 12, 2005 02:54PM
1969
August 18, 2005 11:21AM
1851
August 18, 2005 06:50PM
2145
August 19, 2005 02:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.