Remote MySQL Lag

[EchoHost]

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?

 

[Anishts]

hi

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

 

[EchoHost]

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?

 

[Anishts]

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...

 

[david510]

Type the following command and see which mysql process is talking much connection

mysqladmin -i2 processlist