bytes in Recv-Q not processed by mysql
Jatin Davey <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
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