MySQL SELECT query block other applications (no replies)
(MySQL.com) I run and a c# .net application that makes a SELECT query to MySQL server that needs 8 seconds to respond.
During these 8 seconds all the rest of applications running in the same PC are blocked.
There is a method to avoid blocking other aplic
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 15:36:50