Slow mysql performance between 2 servers

view full story

http://serverfault.com – I have 2 servers, both running Ubuntu server 11.10. The first server runs Apache and PHP and it connects to a Mysql database on the second server. The problem is slow mysql response on the second server.mysql logs does not show any errros other than: 120526 12:56:27 [Note] Plugin 'FEDERATED' is disabled. but that does not prevent mysql from starting/restarting. I tried to run queries from inside the mysql server using the same php app on the first server and it was very fast. but when the same php app requests data from the first server to the mysql server the response is really slow and the (HowTos)