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
3297
July 28, 2005 01:24PM
Re: MySQL Server crashes - spawning too many threads.
2085
July 28, 2005 03:27PM
2022
July 28, 2005 04:02PM
2414
July 28, 2005 05:50PM
1948
July 28, 2005 06:50PM
1983
July 28, 2005 07:37PM
2499
July 30, 2005 11:36AM
1849
August 01, 2005 01:54PM
2784
August 12, 2005 02:54PM
1946
August 18, 2005 11:21AM
1826
August 18, 2005 06:50PM
2112
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.