Example Analysis of sql query in openstack mysql Table

This article mainly introduces "openstack mysql table sql query example analysis". In daily operation, I believe many people have doubts about openstack mysql table sql query example analysis problems. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "openstack mysql table sql query example analysis". Next, please follow the editor to study!

one

Important log: / var/log/nova-all.log

List the virtual machine and the name of the node 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 lists the name of the image, ID, and the use of the floating IP of the list of nodes where the virtual machine resides

Instance table

The UUID of uuid- native KVM virtual machine can check the instance_id_ mappings table separately.

Display_name---- instance name

The ID of the user to which user_id---- belongs?

Project_id---- project ID?

Image_ref---- image ID?

Deleted----0 indicates that it has not been deleted

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 | YES | | NULL | | project_id | varchar | YES | MUL | NULL | image_ref | | varchar | YES | | NULL | kernel_id | varchar | YES | | NULL | | ramdisk_id | varchar (255) | YES | | NULL | | launch_index | int (11) | | | YES | | NULL | key_name | varchar | 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 | YES | | NULL | host | varchar | YES | MUL | NULL | | user_data | mediumtext | YES | | NULL | reservation_id | | | varchar | YES | MUL | NULL | scheduled_at | datetime | YES | | NULL | | launched_at | datetime | YES | | NULL | | terminated_at | datetime | YES | MUL | NULL | | | | display_name | varchar | YES | | NULL | display_description | varchar | YES | | NULL | | availability_zone | varchar | YES | | NULL | | locked | tinyint | (1) | YES | | NULL | os_type | varchar | YES | | NULL | | launched_on | mediumtext | YES | | NULL | | instance_type_id | int (11) | YES | | | NULL | | vm_mode | varchar | YES | | NULL | | uuid | varchar (36) | YES | UNI | NULL | | architecture | varchar | YES | | NULL | | | root_device_name | varchar | YES | | NULL | access_ip_v4 | varchar (39) | YES | | NULL | | access_ip_v6 | varchar (39) | YES | | NULL | config_drive | | | varchar | YES | | NULL | task_state | varchar | YES | MUL | NULL | | default_ephemeral_device | varchar | YES | | NULL | | default_swap_device | varchar | 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 | 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) so far On the "openstack mysql table sql query example analysis" study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!