Slow response from MySQL on other server
I have a relatively big website so I am trying to serve web from one server and process MySQL on another server.
The problem is that when the website and database are on the same server , website pages are very fast but when I put the website on another server (both are dual xeons in ev1servers.net with the same apache configuration) it becomes very very slow (2 seconds when served in the same server in comparison to 8-12 seconds or slower on the other).
I have tested connection speed using FTP and I was able to transfer 15M Bits/s. Amount of data being transfered for each page is less than 20KBytes and website is not acive yet so this is the only data being transfered between two servers. (so why is it slow?!!!)
1- Would someone please advise if the problem is from connection speed between two servers?
2- Does a "Private Rack" service help with the problem? (as servers are on a dedicated high speed switch)
My MySQL config:
You need to have a better idea where the bottleneck lies before you can even speculate about what might or might not help fix it.
The first place to look is in the application that uses mySQL.
Here's a link that might help:
could be the kind of connection are you using in your webapplication.
are you sure are you using pconnect (if php) ? any way persistent connection ?
entropia is exactly right.
But that's just one of many, many possibilities (albeit a really excellent place to start looking ;-))
The point I was trying to make is that you really need to do some more analysis before you start throwing hardware at the problem.
IMHO .. PSM
|All times are GMT -5. The time now is 01:58 AM.|