nova-manage floating (list|create|delete) all execute very slowly. Creating/deleting realistic numbers of IPs can take hours, and simply listing them takes multiple seconds. These operations are essentially inserting/deleting/selecting from a mysql database, and should all be fast (< 1 second).
Reference values:
On a development cloud that we have, creating a /16 block of IPs (65,536 IPs) took around two hours, and simply doing the SQL SELECT to print them out with nova-manage floating list took 10 seconds.
Implementation details:
Looking at the nova-manage command, the create/delete commands spend the majority of their time in the db.floating_ip_create()/destroy() functions, spending roughly .2s to execute each on our machines.
The list command needs to be investigated more.
We suspect that the issues lies in using sqlalchemy inefficiently, most likely using a new transaction to update every single row. Assuming that sqlalchemy supports pipelining multiple row updates into a single transaction, we think this could improve execution speeds a lot.
Might be related to https:/