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

Hi,

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?

Thanks
tomp_glAsked:
Who is Participating?
 
tomp_glConnect With a Mentor Author Commented:
Problem seems to be solved. Solution was to add the following to /etc/my.cnf:

engine-condition-pushdown
skip-name-resolve
0
 
fosiul01Commented:
HI

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 ??
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.