Hello, I've performed the SRU verification and all looks good on my end.
Firstly, after deploying a fresh openstack cloud I ran the attached test script, which benchmarks performance and response times from the neutron api service. The following results show the performance with the default ext_net and private networks, admin security group, and no rbac policies as a baseline ======================== Performance in virtually empty fresh cloud ======================== Time taken for network list: 1496 ms Time taken for security group list: 1274 ms Time taken for network rbac list: 1194 ms Time taken for network show: 1408 ms Then I used a script to create 1000 projects, 10 networks, and 10 security groups, and share each network and security group with each project. Effectively creating 20000 RBAC rules, which is slightly less than the ~30000 in the original bug report. At this point I ran the same test script, which produced the following performance: ======================== Performance of unpatched with 20000 RBAC rules ======================== Time taken for network list: 9330 ms Time taken for security group list: 7824 ms Time taken for network rbac list: 20576 ms Time taken for network show: 1544 ms Here I enabled proposed and ran the same test ======================== Performance of proposed with 20000 RBAC rules ======================== Time taken for network list: 2400 ms Time taken for security group list: 1952 ms Time taken for network rbac list: 13727 ms Time taken for network show: 1341 ms As expected, listing the networks and security groups requires significantly less time due to the lower cardinality of the returned set by the /network API. In the original report this endpoint was noted as being particularly affected. Thanks! ** Attachment added: "test.sh" https://bugs.launchpad.net/ubuntu/+source/python-neutron-lib/+bug/2092217/+attachment/5867728/+files/test.sh ** Tags removed: verification-needed verification-needed-jammy ** Tags added: verification-done verification-done-jammy -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2092217 Title: [SRU] Missing Group-By Optimization Backport in Yoga and Antelope To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/2092217/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
