MySQL database tables are using the MyISAM engine
Bug #741274 reported by
justinsb
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Low
|
Jason Cannavale |
Bug Description
MySQL database tables seem to be using the MyISAM engine. They should use InnoDB.
Related branches
lp:~jcannava/nova/lp741274
- Dan Prince (community): Abstain
- Rick Harris (community): Approve
- Paul Voccio (community): Approve
- Jay Pipes (community): Approve
- Vish Ishaya (community): Approve
-
Diff: 84 lines (+66/-0)2 files modifiedAuthors (+1/-0)
nova/db/sqlalchemy/migrate_repo/versions/022_set_engine_mysql_innodb.py (+65/-0)
Changed in nova: | |
assignee: | nobody → Jason Cannavale (jason-cannavale-com) |
Changed in nova: | |
status: | Triaged → In Progress |
Changed in nova: | |
status: | In Progress → Fix Committed |
Changed in nova: | |
milestone: | none → diablo-2 |
Changed in nova: | |
milestone: | diablo-2 → 2011.3 |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Agreed. The way to do this is to use mysql_engine= 'InnoDB' in the Table constructors. In the case of Nova, a migrate script should be done. Simple enough migrate script, though :) Just make a 0XX_mysql_ upgrade. sql script that contains a bunch of these:
ALTER TABLE servers ENGINE=InnoDB;
repeat that for each table in the DB...