Speed up MySQL

GameCP uses your MySQL database for communication with your remote server(s). The connection speed from your master - to remote - and back - is based on your MySQL servers connection speed.

Recently I found DNS issues can easily slow down a MySQL server taking up to 4.5 seconds per query - instead of the .5 or so it normally takes.

Disabling name resolving (dns) will help speed up your server.

Add skip-name-resolve to my.cnf

Warning! Any MySQL user with a hostname, not an ip or %, will probably not work after you make this change!

• Login to your database server via SSH or RDP
• Locate your my.cnf file
• Edit it
• Add the following

skip-name-resolve

• Restart MySQL
• Enjoy a faster mysql server!