We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


Extreme MySql Connector Lag, but only from one particular building

recruitit asked
Medium Priority
Last Modified: 2012-05-06
Right, this is the final straw.

We have be suffering heavily with this MySql Latency issue for months now.

Its gotten so bad that their are functions within our application that can no longer be used.

Let me give you the run down of our setup.

User logs into PC, PC has a C# application that utilises the MySql Connector to connect to a database hosted on a remote site.  So user opens application, Logs In (This is a verification of user details on the remote site using MySql Connector).  The application obviously sends the connection on port 3306, it goes through 1 switch, then through our router, out to our broadband line, and in to the web, where it gets routed to our remote site which hosts the MySql Database, and obviously makes the connection.

Periodically, and in particular today, we get enormous connection lag, to the point where the application is completely un-usable.  This app is a central part to our companies functioning so its a very critical that we get this fixed.

Another observation has shown that our Office in New York in the United States, experiences absolutely no latency/lag issues when connecting to the database with the same application.  Even during the times were our application in the UK is slamming the ground and getting rug burn, the US site is running crystal clear without any problem whatsoever.

I have done broadband speed testing, connection performance testing, rebooting the database, purging the connections, rebooting our router, checked mysql database configurations (which should make a difference anyway since the US site doesnt have any problems).

Also, our website utilises the same database, and again absolutely no problems there, its always running fine. (I always check the website, and the US site when we are having these lag issues).

A tracert to the remote site shows lots of time outs from our building, but from the US site there is no timeouts.  I dont know if this is at all relevant.

At the present moment our download speed shows ~5000kbps with 663 kbps upload speed.
And at this very moment, we are having enormous lag issues with the program.

I am at my wits end and this whole thing is going to make my hair fall out.

MySql Database Version  5.0.45
MySql Connector Version (Runtime Version v2.0.50727)

Personally, the whole thing seems to point at some routing problem in the web somewhere, but I dont really know.  Its such a nightmare, and if it IS the web, we are basically up the creak without a paddle because there is absolutely nothing we can do about it.  Unless there is someway to choose the specific route that the application takes to the remote site.

I once thought it might be the application, but I have done extensive testing that shows that this is not the case.  The code can simply be 4 lines of code, essentially just declaring a new MySql Connection, and then opening the connection, I have tested this and we still get the same problem.

I would really, really appreciate it if someone can resolve this issue for me.
Watch Question

Top Expert 2008



I just inserted our broadband hostname and ip address in the MySql servers host file, ill report back if that helps any.
Top Expert 2008
When a client connects to mysql server, the server does a dns lookup on the connecting ip address. If this dns lookup is slow, you will get problems like those you describe.

Try starting the server with the --skip-name-resolve parameter.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Great, this appears to have fixed it!

Thanks very much, amazing how such a simple thing can lead to such disaster.



This did not fix the problem at all.

We are still stuck with this problem.

Today our mysql connector is completely useless.  Over 1 minute to open a connection to the MySql Database, or timeout.
Top Expert 2008

Have you restarted the server, is it running with --skip-name-resolve ?

If it is, I have no other suggestion as to what the problem can be. You must ask a new question to get the attention of other experts.


Yep, also tried it from the Advanced Networking Configuration.  This option also blocks Plesk from interacting with the database.
Top Expert 2008

>> This option also blocks Plesk from interacting with the database

This could be because the plesk mysql account is configured with a host name, not an ip address. Check the table mysql.user, the Host column for the Plesk user. Set it to an ip address, if possible.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.