On Thu, Oct 26, 2017 at 09:23:50PM -0500, Matt Riedemann wrote: > Nova has had this long-standing known performance issue if you're filtering > a large number of instances by IP. The instance IPs are stored in a JSON > blob in the database so we don't do filtering in SQL. We pull the instances > out of the database, deserialize the JSON and then apply a regex filter > match in the nova-api python code. > > At the Queens PTG we talked about possible ways to fix this and came up with > this nova spec: > > https://specs.openstack.org/openstack/nova-specs/specs/queens/approved/improve-filter-instances-by-ip-performance.html > > The idea is to have nova get ports from neutron and apply the IP filter in > neutron to whittle down the ports, then from that list of ports get the > instances to pull out of the nova database. > > One issue that has come up with this is neutron does not currently support > regex filters when listing ports. There is an RFE for adding that: > > https://bugs.launchpad.net/neutron/+bug/1718605 > > The proposed neutron implementation is to just do SQL LIKE substring > matching in the database. Can you use RLIKE/REGEX? or is that too MySQL specific ? Yours Tony. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 488 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20171027/885fa9e5/attachment.sig>