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.

MySQL playing up

Discussion in 'General Discussion' started by Jeewhizz, Jan 26, 2004.

  1. Jeewhizz

    Jeewhizz Well-Known Member

    Joined:
    Mar 12, 2003
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    London, England
    Since we upgraded al our servers to 8.7.0 R 26, we've seen massive spikes in our loads, hitting 90+ - somtiems so bad, we have to get the data center to reboot as it becomes unresponsive.

    This has happened on both servers, running RH 7.3 or RH 9.

    It looks like it has something to do with MySQL - mysql keeps going down with this error:

    Warning: mysql_connect(): Too many connections in /home/user/public_html/forum/index.php on line 67

    Anyone know how to solve this?

    Cheers,

    Jee
     
  2. WebmastTroy

    WebmastTroy Well-Known Member

    Joined:
    Apr 28, 2002
    Messages:
    85
    Likes Received:
    0
    Trophy Points:
    6

    I would check that script to make sure it's not looping for some reason. Also in SSH, type: hdparm -d /dev/hda (it should say on).

    If that didn't help, you might try downgrading to Stable to see if that helps. I've never heard of MySQL doing that unwarranted.
     
  3. Jeewhizz

    Jeewhizz Well-Known Member

    Joined:
    Mar 12, 2003
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    London, England
    It happens all over the server. I.e. on every site that uses mysql - they will get the same error.

    How would you find the script in that case?
     
  4. myusername

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    691
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    chown -R us.*yourbase*
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Same issue here. I have a process listed when I run top that says loop0 is that perhaps a process that needs killed? How would I prevent it from looping again next time they run their script? How can i determin the site that started the loop?

    Thanks,

    Matt
     
Loading...

Share This Page