Hi, would like help on how to start troubleshooting max connection issue.
already set max 500 but after a time mariadb gets full wit these type of connections:
| 117555 | librenms | localhost | librenms | Prepare | 16024 | Opening tables | select config_name, config_value from config | 0.000 |
| 117556 | librenms | localhost | librenms | Prepare | 15964 | Opening tables | select config_name, config_value from config | 0.000 |
| 117557 | librenms | localhost | librenms | Prepare | 15904 | Opening tables | select config_name, config_value from config | 0.000 |
| 117558 | librenms | localhost | librenms | Prepare | 15904 | Opening tables | select config_name, config_value from config | 0.000 |
| 117559 | librenms | localhost | librenms | Prepare | 15904 | Opening tables | select config_name, config_value from config
what can it be? what process creates these connection?
many thanks
still the same issues everyday, no idea why librenms is causing this
| 50443 | librenms | localhost | librenms | Execute | 123291 | After opening tables | select config_name, config_value from config | 0.000 |
| 50444 | librenms | localhost | librenms | Execute | 123286 | After opening tables | select config_name, config_value from config | 0.000 |
| 50445 | librenms | localhost | librenms | Execute | 123286 | After opening tables | select config_name, config_value from config | 0.000 |
| 50446 | librenms | localhost | librenms | Execute | 123286 | After opening tables | select config_name, config_value from config | 0.000 |
| 50447 | librenms | localhost | librenms | Execute | 123286 | After opening tables | select config_name, config_value from config | 0.000 |
| 50448 | librenms | localhost | librenms | Execute | 123231 | After opening tables | select config_name, config_value from config | 0.000 |
| 50449 | librenms | localhost | librenms | Prepare | 123231 | Opening tables | select config_name, config_value from config | 0.000 |
| 50450 | librenms | localhost | librenms | Prepare | 123225 | Opening tables | select config_name, config_value from config | 0.000 |
| 50451 | librenms | localhost | librenms | Prepare | 123225 | Opening tables | select config_name, config_value from config | 0.000 |
| 50452 | librenms | localhost | librenms | Prepare | 123225 | Opening tables | select config_name, config_value from config | 0.000 |
| 50453 | librenms | localhost | librenms | Prepare | 123225 | Opening tables | select config_name, config_value from config | 0.000 |
| 50454 | librenms | localhost | librenms | Prepare | 123171 | Opening tables | select config_name, config_value from config | 0.000 |
| 50455 | librenms | localhost | librenms | Prepare | 123164 | Opening tables | select config_name, config_value from config | 0.000 |
| 50456 | librenms | localhost | librenms | Prepare | 123164 | Opening tables | select config_name, config_value from config | 0.000 |
| 50457 | librenms | localhost | librenms | Prepare | 123164 | Opening tables | select config_name, config_value from config | 0.000 |
| 50458 | librenms | localhost | librenms | Prepare | 123164 | Opening tables | select config_name, config_value from config | 0.000 |
| 50459 | librenms | localhost | librenms | Prepare | 123111 | Opening tables | select config_name, config_value from config | 0.000 |
| 50460 | librenms | localhost | librenms | Prepare | 123111 | Opening tables | select config_name, config_value from config | 0.000 |
| 50461 | librenms | localhost | librenms | Prepare | 123111 | Opening tables | select config_name, config_value from config | 0.000 |
| 50462 | librenms | localhost | librenms | Prepare | 123111 | Opening tables | select config_name, config_value from config | 0.000 |
| 50463 | librenms | localhost | librenms | Prepare | 123111 | Opening tables | select config_name, config_value from config | 0.000 |
| 50464 | librenms | localhost | librenms | Prepare | 123103 | Opening tables | select config_name, config_value from config | 0.000 |
| 50465 | librenms | localhost | librenms | Prepare | 123103 | Opening tables | select config_name, config_value from config | 0.000 |
| 50466 | librenms | localhost | librenms | Prepare | 123103 | Opening tables | select config_name, config_value from config | 0.000 |
| 50467 | librenms | localhost | librenms | Prepare | 123103 | Opening tables | select config_name, config_value from config | 0.000 |
| 50468 | librenms | localhost | librenms | Prepare | 123051 | Opening tables | select config_name, config_value from config | 0.000 |
| 50469 | librenms | localhost | librenms | Prepare | 123042 | Opening tables | select config_name, config_value from config | 0.000 |
| 50470 | librenms | localhost | librenms | Prepare | 123042 | Opening tables | select config_name, config_value from config | 0.000 |
| 50471 | librenms | localhost | librenms | Prepare | 123042 | Opening tables | select config_name, config_value from config | 0.000 |
| 50472 | librenms | localhost | librenms | Prepare | 123042 | Opening tables | select config_name, config_value from config | 0.000 |
| 50473 | librenms | localhost | librenms | Prepare | 122991 | Opening tables | select config_name, config_value from config | 0.000 |
| 50474 | librenms | localhost | librenms | Prepare | 122981 | Opening tables | select config_name, config_value from config | 0.000 |
| 50475 | librenms | localhost | librenms | Prepare | 122981 | Opening tables | select config_name, config_value from config | 0.000 |
| 50476 | librenms | localhost | librenms | Prepare | 122981 | Opening tables | select config_name, config_value from config | 0.000 |
| 50477 | librenms | localhost | librenms | Prepare | 122981 | Opening tables | select config_name, config_value from config | 0.000 |
| 50478 | librenms | localhost | librenms | Prepare | 122931 | Opening tables | select config_name, config_value from config | 0.0