Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Remote MySQL Lag

Discussion in 'General Discussion' started by EchoHost, Nov 23, 2006.

  1. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    I have two servers. server1 and server2. I want to have server2 just do mysql.

    One site already runs of server2's mysql (but that's server3 that does that).

    When I switch the db over from server1 to 2 and enable the script it starts to lag really badly and eventually to a point where the site is inaccessible. There are 300 qps but the server should easily be able to handle it so I think somewhere something is getting jammed.

    Any ideas?
     
  2. Anishts

    Anishts Active Member

    Joined:
    Oct 6, 2005
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    156
    hi

    Put skip-name-resolve in [mysqld] section in my.cnf and give a try ...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    Yea I did that, and the load went down from 0.2 to 0.09 (the other server's database stuff) but same problem with the new one.

    Nothing the error log either. Are there any known firewalls that could be preventing connection?
     
  4. Anishts

    Anishts Active Member

    Joined:
    Oct 6, 2005
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    156
    Hi

    Use mytop to view the status of mysql server in server2 . Also try to connect from client machine to server2 from shell using mysql command , and try to execute some queries...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. david510

    david510 Well-Known Member

    Joined:
    Aug 22, 2004
    Messages:
    473
    Likes Received:
    0
    Trophy Points:
    166
    Type the following command and see which mysql process is talking much connection

    mysqladmin -i2 processlist
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice