rendered paste body*************************** 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>