For some reason tables are getting created as default type. There is a
migration in the history to convert tables to InnoDB, but anything created
after that migration will go in as the default type. We can add another
migration to convert all of the other tables, but I think the right method here
might be to set the default table type in mysql to innodb before running
nova-manage db sync.
Vish
On Oct 11, 2011, at 1:55 PM, Nick Sokolov wrote:
> Hi stackers!
>
> I noticed, that tables in database use two database engines instead of two,
> but model descriptions does not override __table_args__ = {'mysql_engine':
> 'InnoDB'}.
> This is design decision or migration_repo bug, or something else?
>
> mysql> select table_name, table_type, engine FROM information_schema.tables;
> +---------------------------------------+-------------+--------+
> | table_name | table_type | engine |
> +---------------------------------------+-------------+--------+
> .... system tables here ....
> | agent_builds | BASE TABLE | MyISAM |
> | auth_tokens | BASE TABLE | InnoDB |
> | block_device_mapping | BASE TABLE | MyISAM |
> | certificates | BASE TABLE | InnoDB |
> | compute_nodes | BASE TABLE | InnoDB |
> | console_pools | BASE TABLE | InnoDB |
> | consoles | BASE TABLE | InnoDB |
> | export_devices | BASE TABLE | InnoDB |
> | fixed_ips | BASE TABLE | InnoDB |
> | floating_ips | BASE TABLE | InnoDB |
> | instance_actions | BASE TABLE | InnoDB |
> | instance_metadata | BASE TABLE | InnoDB |
> | instance_type_extra_specs | BASE TABLE | MyISAM |
> | instance_types | BASE TABLE | InnoDB |
> | instances | BASE TABLE | InnoDB |
> | iscsi_targets | BASE TABLE | InnoDB |
> | key_pairs | BASE TABLE | InnoDB |
> | migrate_version | BASE TABLE | InnoDB |
> | migrations | BASE TABLE | InnoDB |
> | networks | BASE TABLE | InnoDB |
> | projects | BASE TABLE | InnoDB |
> | provider_fw_rules | BASE TABLE | MyISAM |
> | quotas | BASE TABLE | InnoDB |
> | security_group_instance_association | BASE TABLE | InnoDB |
> | security_group_rules | BASE TABLE | InnoDB |
> | security_groups | BASE TABLE | InnoDB |
> | services | BASE TABLE | InnoDB |
> | snapshots | BASE TABLE | InnoDB |
> | user_project_association | BASE TABLE | InnoDB |
> | user_project_role_association | BASE TABLE | InnoDB |
> | user_role_association | BASE TABLE | InnoDB |
> | users | BASE TABLE | InnoDB |
> | virtual_interfaces | BASE TABLE | InnoDB |
> | virtual_storage_arrays | BASE TABLE | MyISAM |
> | volume_metadata | BASE TABLE | MyISAM |
> | volume_type_extra_specs | BASE TABLE | MyISAM |
> | volume_types | BASE TABLE | MyISAM |
> | volumes | BASE TABLE | InnoDB |
> | zones | BASE TABLE | InnoDB |
> +---------------------------------------+-------------+--------+
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to : openstack@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to : openstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help : https://help.launchpad.net/ListHelp
