← Back to team overview

openstack team mailing list archive

Re: [Nova] MySQL drivers in DB

 

I do not know from where that comes, but I would consider it a bug and
that there is no good reason in this context to be using MyISAM for any
purpose.

On 10/11/2011 01: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


References