[openstack-dev] [Ceilometer] SQL meter table schema improvements
jaypipes at gmail.com
Wed Aug 14 16:42:29 UTC 2013
I submitted a bug report to improve the schema of the meter table to
This would only affect the SQL storage driver.
Interested in hearing thoughts on the above recommendations, which are:
1) Replace counter_type with an integer column counter_type_id that
references a lookup table (counter_type)
2) Replace counter_unit with an integer column counter_unit_id that
references a lookup table (counter_unit)
3) Replace counter_name with an integer column counter_id that
references a lookup table (counter)
Just those three changes would reduce the overall row size for records
in the meter table by about 10%, by my calculations, which is a good
improvement for a relatively painless set of modifications.
More information about the OpenStack-dev