Open Stack

Hi all,

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

https://bugs.launchpad.net/ceilometer/+bug/1211985

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.

Thanks,
-jay