← Back to team overview

openstack team mailing list archive

Re: [Nova] MySQL drivers in DB

 


On 10/11/2011 02:15 PM, Vishvananda Ishaya wrote:
> 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@xxxxxxxxxxxxxxxxxxx Unsubscribe :
>> https://launchpad.net/~openstack More help   :
>> https://help.launchpad.net/ListHelp
> 
> 
> _______________________________________________ Mailing list:
> https://launchpad.net/~openstack Post to     :
> openstack@xxxxxxxxxxxxxxxxxxx Unsubscribe :
> https://launchpad.net/~openstack More help   :
> https://help.launchpad.net/ListHelp
> 


References