[openstack-dev] [Ceilometer] MySQL performance and Mongodb backend maturity question
Daniele Venzano
daniele.venzano at eurecom.fr
Thu Sep 25 09:40:11 UTC 2014
On 09/25/14 10:12, Qiming Teng wrote:
> Yes, just about 3 VMs running on two hosts, for at most 3 weeks. This
> is leading me to another question -- any best practices/tools to
> retire the old data on a regular basis? Regards, Qiming
There is a tool: ceilometer-expirer
I tried to use it on a mysql database, since I had the same table size
problem as you and it made the machine hit swap. I think it tries to
load the whole table in memory.
Just to see if it would eventually finish, I let it run for 1 week
before throwing away the whole database and move on.
Now I use Ceilometer's pipeline to forward events to elasticsearch via
udp + logstash and do not use Ceilometer's DB or API at all.
Best,
Daniele
More information about the OpenStack-dev
mailing list