[openstack-dev] [Ceilometer] SQL meter table schema improvements

Jay Pipes jaypipes at gmail.com
Wed Aug 14 16:42:29 UTC 2013

Hi all,

I submitted a bug report to improve the schema of the meter table to 
reduce duplication:


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 mailing list