Title
#fleet
c

Coleton

03/02/2022, 8:50 AM
I have a performance issue in regards to Software inventory (>1m request times). We have around 20k hosts, and I just updated to 4.10. During the page load, it does increase the load of the database a bit, but still isn't maxing out. Fleet instances don't really change. Horizontal deployment on GCP Kubernetes connecting to cloud managed MySQL. Pods are a bit beefy and don't increase load when the request is happening. Is this a known issue or something related to my deployment?
Tomas Touceda

Tomas Touceda

03/02/2022, 2:39 PM
Hi Coleton, there are some things that are more resource hungry than others. We try to optimize things as much as possible though. Do you mind creating an issue with this data https://github.com/fleetdm/fleet/issues/new/choose so that we can track this and look into it?
Luke Heath

Luke Heath

03/02/2022, 6:17 PM
@Coleton The software request does take a bit for larger deployments, but shouldn't be taking that long. For example, in our load test environment we have 88K software items and it takes 11s to load.
Benjamin Edwards

Benjamin Edwards

03/31/2022, 7:37 PM
@Coleton from the second screenshot it appears as though you might be running
db-standard-4
? Temporarily can you bump up the CPU count on the Cloud MySQL instance? I suspect that is the bottleneck at the moment. If you see improvements from just vertically scaling, we might have a better idea of whats going on.