• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Extreme MySql Connector Lag, but only from one particular building

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 5.2.5.0 (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.
0
recruitit
Asked:
recruitit
  • 4
  • 4
1 Solution
 
Roger BaklundCommented:
0
 
recruititAuthor Commented:
I just inserted our broadband hostname and ip address in the MySql servers host file, ill report back if that helps any.
0
 
Roger BaklundCommented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
recruititAuthor Commented:
Great, this appears to have fixed it!

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

Cheers
0
 
recruititAuthor Commented:
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.
0
 
Roger BaklundCommented:
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.
0
 
recruititAuthor Commented:
Yep, also tried it from the Advanced Networking Configuration.  This option also blocks Plesk from interacting with the database.
0
 
Roger BaklundCommented:
>> 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.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now