[openstack-dev] [Ceilometer] SQL meter table schema improvements
julien at danjou.info
Wed Aug 14 16:52:39 UTC 2013
On Wed, Aug 14 2013, Jay Pipes wrote:
> I submitted a bug report to improve the schema of the meter table to reduce
> 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.
That means we'll have to do 3 joins most of the time. Is that less
costly than fetching these right away from the record?
-- Free Software hacker - freelance consultant
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 835 bytes
Desc: not available
More information about the OpenStack-dev