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

Julien Danjou 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
> 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.

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?

-- 
Julien Danjou
-- Free Software hacker - freelance consultant
-- http://julien.danjou.info
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 835 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20130814/0c77313c/attachment.pgp>


More information about the OpenStack-dev mailing list