MySQL Forums
Forum List  »  NDB clusters

MySQL Command Timeout 1 second takes 6 seconds to timeout
Posted by: Dev Das
Date: July 20, 2015 06:06PM

Hi,

We are working on a production environment running MySQL cluster 5.6.15-ndb-7.3.4-cluster; and the client application (VB.Net) connects to the cluster using MySQL .Net Connector 6.9.4.

The connection string to be used is:
Server=10.0.0.xxx;User ID=xxxxxxxx;Password=xxxxxxxxx;Database=xxxxx;Port=xxxx;Connection LifeTime=600;Max Pool Size=50;Min Pool Size=10;Convert Zero Datetime=True;Connection Timeout=1;

The connection timeout of 1 seconds, ensures that the connection has to succeed in 1 second, and that works correctly. Further to this we use MySQL Command to populate MySQL DataReader.

ADO Command is used:
MySQL_Command.Connection = MySQL_Connection 'This is already connected successfully
MySQL_Command.CommandTimeout = 1 '1 second (that is correct)
MySQL_Command.CommandText = SQL_String
MySQL_DataReader = MySQL_Command.ExecuteReader 'This throws exception the following exception

[5: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]

This is correct message as the exception kicks in 1.187 seconds, and the application does take care of this, by initiating a new connection, and re-issuing the request.

But on the same code, with the same command timeout, we are also observing an exception kicking in after 6.552 seconds, this is not acceptable with our application.

Our application is a telecom application, and response time requirements are immediate, and does handle a big number of transactions without any error or timeout. As per the application, it does handle timeout exceptions (which happens rarely); and if exception kicks in, the connection are re-connected, and the commands are called again. Everything works the way it should.

But once in a while we will hit the same exception with a timeout of 6+ seconds; which should not happen as Commandtimeout is set to 1.

Would request, if someone has noticed similar behavior and have a suggestion for the same.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Command Timeout 1 second takes 6 seconds to timeout
2688
July 20, 2015 06:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.