On 08/14/2013 04:12 PM, Dan Prince wrote:
----- Original Message -----
From: "Jay Pipes" <jaypi...@gmail.com>
To: "OpenStack Development Mailing List" <openstack-dev@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
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
