[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2009-04-30
Medium Priority
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

tomp_gl earned 0 total points
ID: 24276564
Problem seems to be solved. Solution was to add the following to /etc/my.cnf:

LVL 29

Expert Comment

ID: 24277212

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 ??

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Suggested Courses
Course of the Month17 days, 16 hours left to enroll

831 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