2
votes
3answers
615 views

Tool to test MySQL latency [closed]

I want to compare the latency of my web application against two different MySQL servers: one a local machine and one hosted via Amazon RDS. What would be a good, free, and (preferably) easy tool to ...
0
votes
1answer
188 views

What is the best way to detect how/where server latency occurs?

I'm managing a small social media site, and its been for the past few days experiencing intermittent server lags. The site will choke loading a page, and moments later, the same page will have no ...
1
vote
5answers
4k views

MySQL performance over a (local) network much slower than I would expect

MySQL queries in my production environment are taking much longer than I would expect them too. The site in question is a fairly large Drupal site, with many modules installed. The webserver (Nginx) ...
4
votes
3answers
179 views

run local MySQL instance for fast mysql_real_escape_string calls

Currently all MySQL data/API calls are handled by a remote DB cluster (i.e. network latency is a factor in total script execution time). To reduce execution time in this context, would it be sensible ...