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

Jay Pipes jaypipes at gmail.com
Wed Aug 14 20:19:56 UTC 2013


On 08/14/2013 04:12 PM, Dan Prince wrote:
> ----- 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.
>
> Jay:
>
> 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?

I'll try and create a largish ceilo installation and get some numbers to 
show the benefits.

Thanks,
-jay



More information about the OpenStack-dev mailing list