I have determined this is caused by SQL backends. a SQL backend on ceilometer apparently is a very bad idea. This should be made into a documentation bug.
** No longer affects: ceilometer (Ubuntu) ** Summary changed: - 'ceilometer *-list' too slow to respond + Using SQL backend is non-functional ** Description changed: On a new system 'ceilometer meter-list' replies within a few seconds. Once a few days of data have been collected 'ceilometer meter-list' - slows to 10+ minutes to reply. This is true when using either Mongo or - MySQL. During the query it appears there is an excessive amount of SQL + slows to 10+ minutes to reply. This is true when using any SQL backend. + During the query it appears there is an excessive amount of SQL happening. This was tested on Ubuntu Precise using following packages: ii ceilometer-api 2013.1-0ubuntu1~cloud ceilometer api service ii ceilometer-collector 2013.1-0ubuntu1~cloud ceilometer collector service ii ceilometer-common 2013.1-0ubuntu1~cloud ceilometer common files ii python-ceilometer 2013.1-0ubuntu1~cloud ceilometer python libraries ii python-ceilometerclient 1.0.0-0ubuntu1~cloud0 Client library for Openstack ceilometer server. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1180438 Title: Using SQL backend is non-functionally slow To manage notifications about this bug go to: https://bugs.launchpad.net/ceilometer/+bug/1180438/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
