1
重要日志: /var/log/nova-all.log
列出虚机和所在节点的名称
select id,display_name,launched_on,node,deleted from instances where deleted=0 and launched_on in ('node-43','node-44','node-42','node-41');
select id,display_name,launched_on,node,deleted from instances where deleted=0
列出镜像名称,ID,和其虚机所在节点的列表
浮动IP的使用情况
instance表
uuid-----本机KVM虚机的UUID 可以单独查instance_id_mappings表
display_name----实例名称
user_id----所属用户的ID?
project_id----项目ID?
image_ref----镜像ID?
deleted----0表示没有被删除
要
mysql> desc instances;
+--------------------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+-----------------------+------+-----+---------+----------------+
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime