CPU overload help needed ;(

Discussion in 'Site & Server Administration' started by argothiusz, Jun 4, 2008.

0
  1. #1
    :confused:

    28020 mysql 0

    55.1

    4.1 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server1.MYDOMAIN.COM.pid --skip-external-locking

    I got that when I check current CPU usage and that pid thing is killing my server. Any idea what wrong?

    After it has been up to 70% of total CPU usage then kill itself and then up again. Any idea what is going on?
    Thanks
     
    argothiusz, Jun 4, 2008 IP
  2. alcoholhost

    alcoholhost Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    try tuning your mysql
    hxxp://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php
     
    alcoholhost, Jun 5, 2008 IP
  3. hillord

    hillord Well-Known Member

    Messages:
    2,211
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    140
    #3
    nothing is going on. this is a MYSQL process. you will need to tune ur my.cnf , httpd.conf and sysctl.
    if you are not familiar with this. get a system administrator.

    i can try to tune for you for a minimal price. pm me if you are interested.
     
    hillord, Jun 7, 2008 IP
  4. argothiusz

    argothiusz Well-Known Member

    Messages:
    1,500
    Likes Received:
    79
    Best Answers:
    0
    Trophy Points:
    140
    #4
    It's cool. I know what caused it. tuned my.cnf and httpd and it does help :)

    Thanks
     
    argothiusz, Jun 7, 2008 IP
  5. justforlebanon

    justforlebanon Peon

    Messages:
    193
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you have a Chatbox, disable it :)
     
    justforlebanon, Jun 7, 2008 IP