openstack mysql 表_openstack mysql表 sql查询

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              | YES  |     | NULL    |                |

| id                       | int(11)               | NO   | PRI | NULL    | auto_increment |

| internal_id              | int(11)               | YES  |     | NULL    |                |

| user_id                  | varchar(255)          | YES  |     | NULL    |                |

| project_id               | varchar(255)          | YES  | MUL | NULL    |                |

| image_ref                | varchar(255)          | YES  |     | NULL    |                |

| kernel_id                | varchar(255)          | YES  |     | NULL    |                |

| ramdisk_id               | varchar(255)          | YES  |     | NULL    |                |

| launch_index             | int(11)               | YES  |     | NULL    |                |

| key_name                 | varchar(255)          | YES  |     | NULL    |                |

| key_data                 | mediumtext            | YES  |     | NULL    |                |

| power_state              | int(11)               | YES  |     | NULL    |                |

| vm_state                 | varchar(255)          | YES  |     | NULL    |                |

| memory_mb                | int(11)               | YES  |     | NULL    |                |

| vcpus                    | int(11)               | YES  |     | NULL    |                |

| hostname                 | varchar(255)          | YES  |     | NULL    |                |

| host                     | varchar(255)          | YES  | MUL | NULL    |                |

| user_data                | mediumtext            | YES  |     | NULL    |                |

| reservation_id           | varchar(255)          | YES  | MUL | NULL    |                |

| scheduled_at             | datetime              | YES  |     | NULL    |                |

| launched_at              | datetime              | YES  |     | NULL    |                |

| terminated_at            | datetime              | YES  | MUL | NULL    |                |

| display_name             | varchar(255)          | YES  |     | NULL    |                |

| display_description      | varchar(255)          | YES  |     | NULL    |                |

| availability_zone        | varchar(255)          | YES  |     | NULL    |                |

| locked                   | tinyint(1)            | YES  |     | NULL    |                |

| os_type                  | varchar(255)          | YES  |     | NULL    |                |

| launched_on              | mediumtext            | YES  |     | NULL    |                |

| instance_type_id         | int(11)               | YES  |     | NULL    |                |

| vm_mode                  | varchar(255)          | YES  |     | NULL    |                |

| uuid                     | varchar(36)           | YES  | UNI | NULL    |                |

| architecture             | varchar(255)          | YES  |     | NULL    |                |

| root_device_name         | varchar(255)          | YES  |     | NULL    |                |

| access_ip_v4             | varchar(39)           | YES  |     | NULL    |                |

| access_ip_v6             | varchar(39)           | YES  |     | NULL    |                |

| config_drive             | varchar(255)          | YES  |     | NULL    |                |

| task_state               | varchar(255)          | YES  | MUL | NULL    |                |

| default_ephemeral_device | varchar(255)          | YES  |     | NULL    |                |

| default_swap_device      | varchar(255)          | YES  |     | NULL    |                |

| progress                 | int(11)               | YES  |     | NULL    |                |

| auto_disk_config         | tinyint(1)            | YES  |     | NULL    |                |

| shutdown_terminate       | tinyint(1)            | YES  |     | NULL    |                |

| disable_terminate        | tinyint(1)            | YES  |     | NULL    |                |

| root_gb                  | int(11)               | YES  |     | NULL    |                |

| ephemeral_gb             | int(11)               | YES  |     | NULL    |                |

| cell_name                | varchar(255)          | YES  |     | NULL    |                |

| node                     | varchar(255)          | YES  |     | NULL    |                |

| deleted                  | int(11)               | YES  |     | NULL    |                |

| locked_by                | enum('owner','admin') | YES  |     | NULL    |                |

| cleaned                  | int(11)               | YES  |     | NULL    |                |

| ephemeral_key_uuid       | varchar(36)           | YES  |     | NULL    |                |

+--------------------------+-----------------------+------+-----+---------+----------------+

53 rows in set (0.00 sec)

31