MySQL Forums
Forum List  »  Perl

Re: DBD::mysql::st execute failed: Lost connection to MySQL server during query
Posted by: Rick James
Date: September 29, 2011 07:19AM

SHOW TABLE STATUS LIKE 'Inbound'

What percent of the rows have (status = 'n')? Does this percentage fluctuate?

How many rows are returned by
"SELECT FLOOR..."

3 seconds for
> UPDATE InterfaceStatus SET pid = '24221', Status = 'Got ACK', Debug = '1', LastTransaction = NOW(), Transaction = '250418408' WHERE Process = 'CERME_ADT';
This seems unlikely, since Process is the PRIMARY KEY. However, it can happen if InnoDB is too busy with other stuff. Or is this part of a big transaction?

Options: ReplyQuote




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.