Skip to Main Content
Forums

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL client disconnection due to network drop doesn't release threads and shows in processlist

user13795778Nov 21 2016 — edited Nov 22 2016

Here is our case, say you connect to MySQL database over network using any client and the network connection is interrupted/dropped, the processlist still shows the connection. How do we determine if the client has disconnected or dropped? in the below example the client 764PNQ18861LT02 switched off network....

    Id  User    Host                   db                  Command    Time  State     Info                  

------  ------  ---------------------  ------------------  -------  ------  --------  -----------------------

     3  root    localhost:52801        performance_schema  Query         0  starting  show full processlist 

     4  xyz    764PNQ18861LT02:61945  (NULL)              Sleep      1239            (NULL)                

Comments

Post Details

Added on Nov 21 2016
#mysql-user-groups
2 comments
267 views