MySQL Forums
Forum List  »  InnoDB

Re: Strange SELECT lock / timeout
Posted by: Zen Itt
Date: April 17, 2013 11:24PM

Thanks Rick, but I found the solution to the problem and it was strange too, at least for me. I always thought that the time delay that the mysql client returns after each query (for example "120 rows in set (0.27 sec)") was the time that takes to the mysql server to generate that result, but not.

The problem was a network problem! With no relation at all with the mysql server!

So, I found, opposed to what I always thought, that the time after each query showed by the mysql client includes the network delay. The same requests at the same time from a server in the same datacenter as the mysql server and another from another country returns a different time(considerabily different).

Options: ReplyQuote


Subject
Views
Written By
Posted
2327
April 11, 2013 01:58PM
1057
April 11, 2013 02:36PM
768
April 12, 2013 10:14PM
Re: Strange SELECT lock / timeout
925
April 17, 2013 11:24PM


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.