Feb 23, 2025
0
Level 1
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.
Please or to participate in this conversation.