Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table vms has a periodic query duration of 3 min #49

Open
NielsKorschinsky opened this issue Feb 24, 2021 · 1 comment
Open

Table vms has a periodic query duration of 3 min #49

NielsKorschinsky opened this issue Feb 24, 2021 · 1 comment
Labels
invalid This doesn't seem right

Comments

@NielsKorschinsky
Copy link
Member

grafik

It seems like the --daily job has a ~10 min runtime, of which 3 min are soley for the influxdb request to the vms table.
If this is correct and not an mathematic error when generating the statistics, the indices of the vms table should be improved, as well as the kind of data saved and the queried request.
There are 6.6k vm's backuped.

@NielsKorschinsky NielsKorschinsky added bug Something isn't working invalid This doesn't seem right labels Feb 24, 2021
@NielsKorschinsky NielsKorschinsky added this to the 1.1 Release milestone Feb 24, 2021
@NielsKorschinsky NielsKorschinsky removed the bug Something isn't working label Mar 29, 2021
@NielsKorschinsky
Copy link
Member Author

These spikes are also caused by the pageSize, though the query time of 3 Min is way too high. I've also seen Dashboards with about 17 Minutes.
On default load the preferred time is 30 seconds.

Even when looking at query duration per item, vm's is way too high at > 1 second.
This may be caused by a missing SPP-Index, but also by the API-Request parameters.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
invalid This doesn't seem right
Projects
None yet
Development

No branches or pull requests

1 participant