mysql_cleanup

Mysql openstack cleanup

volumes:

use nova;
select id,status,display_name from volumes;
delete from iscsi_targets where volume_id=$id;
delete from volumes where id=$id;

hosts:


select id,uuid,vm_state,display_name from instances;
delete from security_group_instance_association where instance_id=$id;
delete from instance_info_caches where instance_id=$uuid;
delete from instance_metadata where instance_id=$id;
delete from instances where id=$id;


find hosts:
select id,uuid,hostname,host from instances where vm_state='active';