This repository was archived by the owner on Sep 30, 2024. It is now read-only.
This repository was archived by the owner on Sep 30, 2024. It is now read-only.
insights: spike for database connections slowing down insight loading #45472
Open
Description
follow up on #42128
I wonder if it's possible with lower usage all the connections timeout and are closed and then when a new request comes with a rush of new sql it has to pay the cost of reestablishing a number of them.
The default Idle Connection time is 1 min, so if there wasn't any activity to the insightsdb those connections could get closed and then at next insights related page opening a bunch of connections would need to get reestablished.
the slowness we see in some insights, where we hit thousands of ms graphql calls and the traces do not account for this time. however this is not easily reproduceable.
