mmuqiitf's avatar

Debug unclosed connections and network issues

Hello, i have a problem in MySQL when i use MySQL Tuner it's suggest to "Reduce or eliminate unclosed connections and network issues". I see in "SHOW PROCESSLIST" in MySQL and it's looks like this :

Id User Host db Command Time
5 event_scheduler localhost null Daemon 53171
407 technomed_user 127.0.0.1:58242 technomed_asia Sleep 2
408 technomed-adm 156.67.210.123:48898 technomed_new_beta Sleep 0
409 technomed_user 127.0.0.1:58254 technomed_asia Sleep 0
410 technomed_user 127.0.0.1:58258 technomed_asia Sleep 0
411 technomed_user 127.0.0.1:48950 technomed_asia Sleep 1
412 technomed-adm 156.67.210.123:50712 technomed_new_beta Sleep 0
413 technomed_user 127.0.0.1:48958 technomed_asia Sleep 3
414 technomed-adm 156.67.210.123:50724 technomed_new_beta Sleep 3
415 technomed_user 127.0.0.1:48966 technomed_asia Sleep 3
416 technomed-adm 156.67.210.123:50730 technomed_new_beta Sleep 1
417 technomed_user 127.0.0.1:48970 technomed_asia Sleep 3
418 technomed-adm 156.67.210.123:50738 technomed_new_beta Sleep 2
419 technomed-adm 156.67.210.123:50750 technomed_new_beta Sleep 2
420 technomed_user 127.0.0.1:53564 technomed_asia Sleep 1
421 technomed-adm 156.67.210.123:55378 technomed_new_beta Sleep 2
422 technomed-adm 156.67.210.123:55386 technomed_new_beta Sleep 1
472 technomed-adm 103.167.218.50:59791 technomed_asia Query 0

How to debug that in laravel? I want to know why the connection is unclosed.

Thank you.

0 likes
0 replies

Please or to participate in this conversation.