| opendevreview | ZhouHeng proposed openstack/neutron master: always set port addresses https://review.opendev.org/c/openstack/neutron/+/900392 | 01:44 |
|---|---|---|
| opendevreview | Rodolfo Alonso proposed openstack/neutron master: [OVN] Add a new process to spawn ML2/OVN maintenance worker https://review.opendev.org/c/openstack/neutron/+/922074 | 06:32 |
| opendevreview | Merged openstack/neutron stable/2023.1: [FT] Run test_periodic_sync_routers_task tests serially https://review.opendev.org/c/openstack/neutron/+/922282 | 07:11 |
| opendevreview | Niklas Schwarz proposed openstack/neutron-vpnaas master: Add type annotations https://review.opendev.org/c/openstack/neutron-vpnaas/+/911412 | 10:03 |
| opendevreview | Rodolfo Alonso proposed openstack/neutron master: [OVN] Enable the WSGI module for the OVN mechanism driver https://review.opendev.org/c/openstack/neutron/+/922470 | 11:32 |
| opendevreview | Rodolfo Alonso proposed openstack/neutron master: DNM == Test devstack patch 922611 https://review.opendev.org/c/openstack/neutron/+/922613 | 11:35 |
| opendevreview | Rodolfo Alonso proposed openstack/neutron master: [OVN] Add a new process to spawn ML2/OVN maintenance worker https://review.opendev.org/c/openstack/neutron/+/922074 | 12:40 |
| opendevreview | Rodolfo Alonso proposed openstack/neutron master: [OVN] Enable the WSGI module for the OVN mechanism driver https://review.opendev.org/c/openstack/neutron/+/922470 | 12:40 |
| opendevreview | Rodolfo Alonso proposed openstack/neutron master: DNM == Test devstack patch 922611 https://review.opendev.org/c/openstack/neutron/+/922613 | 12:40 |
| *** haleyb is now known as haleyb|out | 13:16 | |
| opendevreview | Lajos Katona proposed openstack/os-ken master: Raise ValuError in case unpack_from returns zero length https://review.opendev.org/c/openstack/os-ken/+/922622 | 13:20 |
| opendevreview | Merged openstack/neutron unmaintained/yoga: fix netns deletion of broken namespaces https://review.opendev.org/c/openstack/neutron/+/914002 | 15:39 |
| mlavalle | haleyb: ack, no meeting | 16:49 |
| racosta | Hi slaweq, do you know if there is any performance metric/optimization in subnet queries when we have thousands of RBAC entries? I'm talking about "SELECT subnets.project_id" with "LEFT OUTER JOIN subnetpoolrbacs" and "LEFT OUTER JOIN networkrbacs" | 17:11 |
| racosta | I enabled slow queries on mysql side and I'm seeing slow queries taking more than 60 seconds. "#Query_time: 74.360740 Lock_time: 0.000995 Rows_sent: 583345 Rows_examined: 1750117" | 17:13 |
| racosta | https://paste.openstack.org/show/blNwLRYrMbf0aUXE3UWE/ | 17:15 |
| racosta | It seems to me that we are exploding this iteration multiple times when we have many elements in the tables used in the left join.... subnets times subnetpoolrbacs times networkrbacs times standardattributes, etc... | 17:18 |
| racosta | And this results in more than 1M rows analyzed... makes sense to you? any idea? | 17:19 |
| racosta | https://paste.openstack.org/show/bytqBT0N5FQ6yCe09dhx/ | 17:21 |
| opendevreview | Merged openstack/neutron unmaintained/xena: fix netns deletion of broken namespaces https://review.opendev.org/c/openstack/neutron/+/914003 | 17:52 |
| opendevreview | Merged openstack/neutron unmaintained/wallaby: fix netns deletion of broken namespaces https://review.opendev.org/c/openstack/neutron/+/913804 | 20:04 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!