3

Slow mysql performance between 2 servers

view full story
linux-howto

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)

u85500's picture
Submitted by u85500 on 05/26/2012 – Made popular on 05/26/2012

Stories similar to Slow mysql performance between 2 servers

MySQL Data Center Replication 17 weeks 4 days ago

I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database.

I basically need to set up multiple MySQL servers in separate geographical locations that will all server the same data set (i.e. If I add data to one server, it will appear on another server relatively quickly).

I have a fresh install of ubuntu 12.04 server edition and mysql server is not starting properly.

I did a simple apt-get install

apt-get install mysql-server

But, it's failing with this error message

root@test:~# mysqld

120618 20:57:32 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release.

I've made some changes to My.cnf to configure Mysql server as below:

innodb_buffer_pool_size = 50M innodb_log_file_size = 15M bulk_insert_buffer_size=25M log-slow-queries = mysql-inja-slow.log

Then I restarted the MySQL server with command below:

service mysqld restart

It reported that MySQL has stopped, but when wanted to start said: [ Faild ].

Recently my Debian Linux server has been experiencing slow web server response times.

I have 2 frontend nginx servers going to 4 backend php-fpm servers which all run Wordpress.

The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:

mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection.

I got a dedicated VPS and installed mysql on it(I am new at this).

Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when the database server was on the same server.

I started with one server running Apache, PHP, MySQL. Now I have split off my web server so I am running all the PHP files on one server and my MySQL is still on the original server. Are there services / programs that I can turn off or uninstall from the MySQL Server now, or do I need to keep httpd (etc) running?

I am hosting a mysql server in a debian 6.0.4 server hosted in linode, the new data is frequently written into the mysql server using R, about 30-40 "write" per minute, about 7 hours a day, 5 days a week.

Recently I found that the mysql server seem to down frequently, always give me error that mysql server cannot be connected through socket.