The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

ABUSING Customers?

Discussion in 'General Discussion' started by AlaskanWolf, Oct 17, 2003.

  1. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    Now, heres a senario many of the larger hosts have seen countless times

    The servers been running great for weeks, then all of a sudeen the load spikes to 3.0+ maybe past 10+

    You check TOP and all it shows is tons of HTTPD and MYSQL processes, not pointing to any one customer

    You do a ps aux, same thing, tons of httpd/sql processes, all pointing to the same thing

    You check WHM and see mysqls load is at 300% CPU, again, not pointing to any one customer

    You do a mysqladmin processlist and it lists only a few, if not any databases running

    Now. What do YOU do in this situation? where do you start? Its apparent that as a host, you need something that will keep track of all the sources, and off the bat, tell you "XXX Customer is currently killing the server" something along those lines.
     
  2. goodmove

    goodmove Well-Known Member

    Joined:
    May 12, 2003
    Messages:
    624
    Likes Received:
    0
    Trophy Points:
    16
    If MySQL is the problem get yourself MyTop! :)
     
  3. jonx

    jonx Member

    Joined:
    Sep 6, 2002
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    WHM's Apache status is somewhat helpful concerning the many httpd processes; however, I don't find this quite sufficient. Anyone have some suggestions?
     
  4. sleuth1

    sleuth1 Well-Known Member

    Joined:
    Mar 16, 2003
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    this can help a bit if you have a lot of clients, check the higher cpu usage accounts over a day in whm, then visit the higher using domains, either by ssh or web browser, look for forums with many users, or weird scripts, cgi forums, or home made php scripts, it is almost certain abusers will show up here sooner or later
     
  5. LS_Drew

    LS_Drew Well-Known Member

    Joined:
    Feb 20, 2003
    Messages:
    187
    Likes Received:
    0
    Trophy Points:
    16
    Yeah, all that stuff will help you find out that it's eximstats that's using all the Mysql :D

    Eximstats, new Exim, Spam Assassin...they've all increased a lot in resource usage lately. No difference in the volume of mail or number of people on the server and whoops...everything's acting up. Eximstats runs mysql processes all the time and sometimes creates huge ones.
     
  6. jonx

    jonx Member

    Joined:
    Sep 6, 2002
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Thanks Drew,

    Anyway to disable eximstats and only run it manually when it's needed?
     
  7. Silverado

    Silverado Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    154
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Backyard - Poolside
    Under Tweak settings you can uncheck the box, almost at the very bottom, that says:
    Exim Stats Daemon (required for smtp bandwidth logging).
    This will disable this feature.
    It not only uses a lot of resources, but it fills the /var logs too.
    The source of this log is
    /var/lib/mysql/eximstats
     
  8. LS_Drew

    LS_Drew Well-Known Member

    Joined:
    Feb 20, 2003
    Messages:
    187
    Likes Received:
    0
    Trophy Points:
    16
    Wow...I didn't even know you COULD disable it! Thank GOD!!

    My servers thank you...you could practically hear them sigh with relief when I killed it! :D


    jonx: I lived without it this long, I think I can go longer. :)
     
Loading...

Share This Page