*************************** 1. row *************************** id: 1 select_type: SIMPLE table: instances type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 26716 Extra: Using where *************************** 2. row *************************** id: 1 select_type: SIMPLE table: fixed_ips_1 type: ref possible_keys: instance_id key: instance_id key_len: 5 ref: nova_test.instances.id rows: 3 Extra: *************************** 3. row *************************** id: 1 select_type: SIMPLE table: networks_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.fixed_ips_1.network_id rows: 1 Extra: *************************** 4. row *************************** id: 1 select_type: SIMPLE table: virtual_interfaces_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.fixed_ips_1.virtual_interface_id rows: 1 Extra: *************************** 5. row *************************** id: 1 select_type: SIMPLE table: networks_2 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.virtual_interfaces_1.network_id rows: 1 Extra: *************************** 6. row *************************** id: 1 select_type: SIMPLE table: floating_ips_1 type: ref possible_keys: fixed_ip_id key: fixed_ip_id key_len: 5 ref: nova_test.fixed_ips_1.id rows: 1 Extra: *************************** 7. row *************************** id: 1 select_type: SIMPLE table: virtual_interfaces_2 type: ref possible_keys: instance_id key: instance_id key_len: 4 ref: nova_test.instances.id rows: 1 Extra: *************************** 8. row *************************** id: 1 select_type: SIMPLE table: networks_3 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.virtual_interfaces_2.network_id rows: 1 Extra: *************************** 9. row *************************** id: 1 select_type: SIMPLE table: instance_types_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.instances.instance_type_id rows: 1 Extra: *************************** 10. row *************************** id: 1 select_type: SIMPLE table: virtual_storage_arrays_1 type: ref possible_keys: instance_type_id key: instance_type_id key_len: 4 ref: nova_test.instance_types_1.id rows: 1 Extra: *************************** 11. row *************************** id: 1 select_type: SIMPLE table: instance_metadata_1 type: ref possible_keys: instance_id key: instance_id key_len: 4 ref: nova_test.instances.id rows: 1 Extra: *************************** 12. row *************************** id: 1 select_type: SIMPLE table: security_group_instance_association_1 type: ref possible_keys: instance_id key: instance_id key_len: 5 ref: nova_test.instances.id rows: 1 Extra: *************************** 13. row *************************** id: 1 select_type: SIMPLE table: security_groups_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.security_group_instance_association_1.security_group_id rows: 1 Extra: mysql> alter table instances add index host (host); *************************** 1. row *************************** id: 1 select_type: SIMPLE table: instances type: ref possible_keys: host key: host key_len: 258 ref: const rows: 51 Extra: Using where *************************** 2. row *************************** id: 1 select_type: SIMPLE table: fixed_ips_1 type: ref possible_keys: instance_id key: instance_id key_len: 5 ref: nova_test.instances.id rows: 3 Extra: *************************** 3. row *************************** id: 1 select_type: SIMPLE table: networks_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.fixed_ips_1.network_id rows: 1 Extra: *************************** 4. row *************************** id: 1 select_type: SIMPLE table: virtual_interfaces_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.fixed_ips_1.virtual_interface_id rows: 1 Extra: *************************** 5. row *************************** id: 1 select_type: SIMPLE table: networks_2 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.virtual_interfaces_1.network_id rows: 1 Extra: *************************** 6. row *************************** id: 1 select_type: SIMPLE table: floating_ips_1 type: ref possible_keys: fixed_ip_id key: fixed_ip_id key_len: 5 ref: nova_test.fixed_ips_1.id rows: 1 Extra: *************************** 7. row *************************** id: 1 select_type: SIMPLE table: virtual_interfaces_2 type: ref possible_keys: instance_id key: instance_id key_len: 4 ref: nova_test.instances.id rows: 1 Extra: *************************** 8. row *************************** id: 1 select_type: SIMPLE table: networks_3 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.virtual_interfaces_2.network_id rows: 1 Extra: *************************** 9. row *************************** id: 1 select_type: SIMPLE table: instance_types_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.instances.instance_type_id rows: 1 Extra: *************************** 10. row *************************** id: 1 select_type: SIMPLE table: virtual_storage_arrays_1 type: ref possible_keys: instance_type_id key: instance_type_id key_len: 4 ref: nova_test.instance_types_1.id rows: 1 Extra: *************************** 11. row *************************** id: 1 select_type: SIMPLE table: instance_metadata_1 type: ref possible_keys: instance_id key: instance_id key_len: 4 ref: nova_test.instances.id rows: 1 Extra: *************************** 12. row *************************** id: 1 select_type: SIMPLE table: security_group_instance_association_1 type: ref possible_keys: instance_id key: instance_id key_len: 5 ref: nova_test.instances.id rows: 1 Extra: *************************** 13. row *************************** id: 1 select_type: SIMPLE table: security_groups_1 type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: nova_test.security_group_instance_association_1.security_group_id rows: 1 Extra: 13 rows in set (0.00 sec) mysql>