SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist webchalkboard's Avatar
    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
    Websites for Sale - Sell websites in a purpose built marketplace
    Then do some Shopping

  2. #2
    SitePoint Evangelist
    Join Date
    Apr 2005
    Location
    Moscow, Russia
    Posts
    557
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi, so what's wrong with it?

  3. #3
    SitePoint Zealot newspire's Avatar
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •