5

Setting up a dedicated mysql server

view full story
linux-howto

http://serverfault.com – 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 think mysql server on the dedicated VPS is just configured wrong, especially with the cache sizes. How do I properly set up the mysql server to gain performance? Or is this not a performance issue? (HowTos)

xskl's picture
Submitted by xskl on 02/01/2012 – Made popular on 02/01/2012

Stories similar to Setting up a dedicated mysql server

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.

Optimizing my MySQL server 1 year 18 weeks ago

I just updated to a 8gb dedicated server from a 3gb vps that can no longer handle my site. I have built a search engine using sphinx fulltext search engine and receive 100k to 200k queries a day "alot of which are googlebot etc". Anyway I need help configuring mysql to a very heavily database driven site.

We are an email marketing company and recently switched our setup to MySQL.

I have a CentOS server fully dedicated to MySQL 5.5 (with innodb tables mostly). Server has 32 GB RAM, SSD disks, and avarage memory usage looks like this:

So about 25GB is in use and about 6.5GB is cached. I am experiencing performance problems with WRITE queries, so I was thinking, is this the optimal cache size?

Percona Server, an enhanced drop-in replacement for MySQL that will allow queries to run faster and more consistently and to consolidate servers on powerful hardware, is now at version 5.6.10-60.2.

Highlights of Percona Server 5.6.10-60.2:

• The Thread Pool patch has been ported from MariaDB.

I am working with a small team to run an internal website running with PHP 5.3.9, MySQL 5.0.77.

1.\ Is there any particular command to find out what application server (like: apache2, mysql-server, backup-server etc) are running inside a dedicated server.

2.\ If I will reboot my dedicated server will they all start automatically ?

3.\ What is the safe way of reboot a dedicated server with all its application server running inside it .

Note: I am in dedicated linux (debian) server.

I am having problems connecting to remote mysql server. I am running two ec2 instances, one has mysql server configured and the other is from where I need to connect to.

Things I have done...

1. I have modified /etc/my.conf to comment out skip-networking and added bind-address to point to mysql server ip. 2. I made sure port 3306 is open for listening. 3.

I've recently asked my server administrator, for my Windows dedicated server, to change the MySQL configuration file (my.cnf) to allow search words of 2 characters or more, from the default of 4.

They said they have changed it, restarted MySQL and re-booted the server but I have seen no changes.