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

Dan Prince dprince at redhat.com
Wed Aug 14 20:12:16 UTC 2013

----- Original Message -----
> From: "Jay Pipes" <jaypipes at gmail.com>
> To: "OpenStack Development Mailing List" <openstack-dev at lists.openstack.org>
> Sent: Wednesday, August 14, 2013 12:42:29 PM
> Subject: [openstack-dev] [Ceilometer] SQL meter table schema improvements
> 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.


Looks promising. Have you done any perf testing or do you have any numbers on how this affects performance other than the data size calculation?

> Thanks,
> -jay
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

More information about the OpenStack-dev mailing list