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.

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:
    6
    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:
    6
    hi

    Put skip-name-resolve in [mysqld] section in my.cnf and give a try ...
     
  3. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    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:
    6
    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...
     
  5. david510

    david510 Well-Known Member

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

    mysqladmin -i2 processlist
     
Loading...

Share This Page