Jatin Davey bytes in Recv-Q not processed by mysql
Jan 27, 2016; 07:42
Jatin Davey
bytes in Recv-Q not processed by mysql
Hi All
In my application while writing to DB , i could see the following output from netstat for a single connection to the mysqld DB.
******************* tcp 18 0 ::ffff:127.0.0.1:3306 ::ffff:127.0.0.1:43029 ESTABLISHED 30850/mysqld keepalive (3517.74/0/0)
*******************
I could see that there are 18 outstanding bytes that are not read by mysql in this connection. This stays on indefinitely in my system and is cleared only until i restart my application. I could see some functional issues as well in my application and when i hit the functional issue i can see the above observation from the netstat -tonp command.
Basically certain threads get into BLOCKED state unable to write to DB. Any help / pointers would be really appreciated.
Thanks Jatin
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!