Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Jun 2005
    Location
    Den Haag
    Posts
    120

    Default Mysql refuses/stalls every xx minutes?

    Hi,

    i use one of my servers as a remote mysql server, but when i am watching the process list, from now and then it looks like my other servers can't connect to mysql?

    Load drops to 0, and after 20 seconds or so, 20 mysql processes are spawned? What is causing this, and more important, how can i stop it?
    Last edited by Freezer; 09-11-2005 at 10:45 AM.

  2. #2
    Member
    Join Date
    Jun 2005
    Location
    Den Haag
    Posts
    120

    Default

    Can this be the memory limit on processes? That if a mysql process uses to much memory it's beeing killed?

    I have a 1,2GB database which mysql is serving, and a 2 of 200mb database's. I have 2GB of ram, so it should be plenty, and on my previous server with the same config but without cpanel no problems...

  3. #3
    Super Moderator This forum account has been confirmed by cPanel staff to represent a vendor. chirpy's Avatar
    Join Date
    Jun 2002
    Location
    Go on, have a guess
    Posts
    13,495

    Default

    Do you have the PRM application installed, and if so, is it that that is killing off mysql? IF it is you should exclude mysql from it.
    Jonathan Michaelson

    Need your cPanel servers secured and tuned?
    cPanel Server Configuration, Security, Recovery and Antivirus/AntiSpam Services
    Developers of the most effective (and free) Firewall & Security Solution for cPanel Servers - csf
    http://www.configserver.com

  4. #4
    Member
    Join Date
    Jun 2005
    Location
    Den Haag
    Posts
    120

    Default

    Quote Originally Posted by chirpy
    Do you have the PRM application installed, and if so, is it that that is killing off mysql? IF it is you should exclude mysql from it.
    When can i configure this and how can i check if i have the Process Resource Monitor installed? I have today's cpu usage in whm? But i can't find the Process Resource monitor?

  5. #5
    cPanel Partner NOC cPanel Partner NOC Badge shashank's Avatar
    Join Date
    Apr 2003
    Posts
    146

    Default

    Check if you have this installed.

    http://rfxnetworks.com/prm.php
    Shashank Wagh.
    Systems Administrator.
    http://www.shashank.net

  6. #6
    Member
    Join Date
    Jun 2005
    Location
    Den Haag
    Posts
    120

    Default

    Quote Originally Posted by shashank
    Check if you have this installed.

    http://rfxnetworks.com/prm.php
    I don't have this installed. I have a standard WHM/cPanel install with no extra options or 3rd party software. But to increase the memory limit on processes looks like it helpes, but i want to be sure this is causing it?

Similar Threads & Tags
Similar threads

  1. MySQL refuses access to everything...
    By ontheweb in forum cPanel and WHM Discussions
    Replies: 6
    Last Post: 04-30-2011, 07:45 PM
  2. mysql restaring every 9-10 minutes
    By shann in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 10-20-2008, 04:01 PM
  3. Help MYSQL is dead and refuses to restart
    By Snowman30 in forum cPanel and WHM Discussions
    Replies: 9
    Last Post: 07-05-2007, 01:58 AM
  4. MySQL Shuts down at 4AM for 10 minutes
    By EchoHost in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 02-15-2005, 01:03 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube