[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: bytes in Recv-Q not processed by mysql
From: Jatin Davey <jashokda () cisco ! com>
Date: 2016-01-27 2:24:38
Message-ID: 56A82796.1080302 () cisco ! com
[Download RAW message or body]
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic