How do I optimize MySQL and TCP for a MySQL remote host?

Posted on 2009-04-30
Last Modified: 2012-05-06

I have recently made a dedicated server dedicated to MySQL and started to access it remotely over a private network. The problem is it becomes incredibly slow when a number of users start surfing my website (it takes 5-15 seconds for the page to load).

When I ping the server MySQL is running on from the client server I get around a 0.1ms latency - is this too high for cluster nodes? I have set MTU and txnqueuelen on both servers' eth0 to 7200 and 1000 respectively.

Are there any mysql config variables I should be adding or tweaking now that the client isn't connecting via unix socket?

Question by:tomp_gl

    Accepted Solution

    Problem seems to be solved. Solution was to add the following to /etc/my.cnf:

    LVL 29

    Expert Comment


    was the problem for  skip-name-resolve ?

    or engine-condition-pushdown ??

    engine-condition-pushdown : looks like for query

    and skip-name-resolve is to do with dns query,

    but which one solved your problem ??

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now