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:
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:
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 ?
OpenStack Development Mailing List (not for usage questions)