Red Hat Bugzilla – Bug 1306325
[scale] - GetStorageConnectionsByStorageTypeAndStatus generate slow query for multiple SD's
Last modified: 2016-08-11 11:05:17 EDT
Description of problem:
SP GetStorageConnectionsByStorageTypeAndStatus response time grow when running
--10 rows \ SD's exe time = ~3.2sec
--1 row \ SD exe time = ~1.2sec
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. 10K vms 12 SD's
execution time ~3 sec and above.
less than 1 sec.
performance improved when using this patch:
*** Bug 1306324 has been marked as a duplicate of this bug. ***
--10 rows \ SD's exe time = 485ms
--1 row \ SD exe time = 495ms
So, IIUC from comment 1 https://gerrit.ovirt.org/#/c/52912/ solved the issue
Moving from 4.0 alpha to 4.0 beta since 4.0 alpha has been already released and bug is not ON_QA.
any chance to back-port?
Allon, do you agree backporting https://gerrit.ovirt.org/52912 into 3.6?
(In reply to Martin Perina from comment #7)
> Allon, do you agree backporting https://gerrit.ovirt.org/52912 into 3.6?
The backport is a bit tricky, but it's easy to verify, and once verified it shouldn't be too risky.
Taking the BZ, and will handle the BZ for 3.6.7, as to not add additional risk to 3.6.6
Messed up the flags a bit here, sorry.
This bug is ON_QA for 4.0 alpha release.
I'll clone it to a new one for 3.6.7 since the schemas have diverged quite a bit, and I'd like it to be verified on both branches.
This bug was fixed and is slated to be in the upcoming version. As we
are focusing our testing at this phase on severe bugs, this bug was
closed without going through its verification step. If you think this
bug should be verified by QE, please set its severity to high and move
it back to ON_QA