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
_______________________________________________
OpenStack-dev mailing list
[email protected]
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
