SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
May 17, 2005, 09:21 #1
- Join Date
- Jan 2005
- Location
- Bristol, UK
- Posts
- 494
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
How many mysqld processes should be running?
Hi,
We have a server and i've just noticed it's got about 40 mysqld processes running. Is this normal? Our load average is about 28! I know that's not normal :'(
Tom
-
May 17, 2005, 11:24 #2
- Join Date
- Apr 2005
- Location
- Moscow, Russia
- Posts
- 557
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hi, so what's wrong with it?
-
Jun 10, 2005, 13:37 #3
- Join Date
- Mar 2005
- Location
- Houston, TX
- Posts
- 118
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
40 mysqld process or threads running at the same time is normal if you have 38 clients connected to your database. 40 processes would be very abnormal for me. I usually have between 100-250 mysql processes running. It just depends on how many clients are using the db.
Run the query:
show process list;
This will tell you who's connected and what they are doing.
A load average of 28 is high unless you have 14 processors which you probably don't. ;-)
Bookmarks