----- 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? > > Thanks, > -jay > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev