18 nova mysql database tables are not explicitly Innodb
Bug #972831 reported by
Sean Dague
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Medium
|
Sean Dague |
Bug Description
The following database tables are set to the database engine default when created (the default on many mysql installations is MyISAM), which may have performance implications due to only table level locking on MyISAM.
agent_builds
aggregate_hosts
aggregate_metadata
aggregates
block_
bw_usage_cache
dns_domains
instance_faults
instance_
provider_fw_rules
s3_images
sm_backend_config
sm_flavors
sm_volume
virtual_
volume_metadata
volume_
volume_types
This could be solved with a migration that forces those tables to Innodb
Changed in nova: | |
assignee: | nobody → Sean Dague (sdague-b) |
status: | New → In Progress |
tags: | added: db |
Changed in nova: | |
importance: | Undecided → Medium |
milestone: | none → folsom-1 |
Changed in nova: | |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | folsom-1 → 2012.2 |
To post a comment you must log in.
Reviewed: https:/ /review. openstack. org/6811 github. com/openstack/ nova/commit/ ff19fd40ea90da1 b47bdaa26522f0a 30ca18e73f
Committed: http://
Submitter: Jenkins
Branch: master
commit ff19fd40ea90da1 b47bdaa26522f0a 30ca18e73f
Author: Sean Dague <email address hidden>
Date: Mon Apr 9 15:19:11 2012 -0400
make all mysql tables explicitly innodb
Fixes bug #972831
Change-Id: I5692ea3a5c03e6 5ac8392ba9697db b4dca285f9c