Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
-
2.5.2, 2.5.3, 2.5.5
-
None
-
Debian 9, Debian 10
Description
I've enabled persistent connections but they are not used.
I have more then 4000 connections in TIME_WAIT state per server
Application connects via PHP 7.4 mysqli
maxctrl show server:
├─────────────────────┼──────────────────────────────────────────────┤
|
│ Statistics │ { │
|
│ │ "active_operations": 1, │
|
│ │ "adaptive_avg_select_time": "373.941us", │
|
│ │ "connections": 289, │
|
│ │ "max_connections": 386, │
|
│ │ "persistent_connections": 0, │
|
│ │ "routed_packets": 37211148, │
|
│ │ "total_connections": 2258233 │
|
│ │ } │
|
├─────────────────────┼──────────────────────────────────────────────┤
|
│ Parameters │ { │
|
│ │ "address": "XXX.XXX.XX.XXX", │
|
│ │ "disk_space_threshold": null, │
|
│ │ "extra_port": 0, │
|
│ │ "monitorpw": null, │
|
│ │ "monitoruser": null, │
|
│ │ "persistmaxtime": 60000, │
|
│ │ "persistpoolmax": 500, │
|
│ │ "port": 3306, │
|
│ │ "priority": 0, │
|
│ │ "proxy_protocol": false, │
|
│ │ "rank": "primary", │
|
│ │ "socket": null, │
|
│ │ "ssl": false, │
|
│ │ "ssl_ca_cert": null, │
|
│ │ "ssl_cert": null, │
|
│ │ "ssl_cert_verify_depth": 9, │
|
│ │ "ssl_cipher": null, │
|
│ │ "ssl_key": null, │
|
│ │ "ssl_verify_peer_certificate": false, │
|
│ │ "ssl_verify_peer_host": false, │
|
│ │ "ssl_version": "MAX" │
|
│ │ } │
|
└─────────────────────┴──────────────────────────────────────────────┘
|