[openstack-dev] [Ceilometer] MySQL performance and Mongodb backend maturity question

Qiming Teng tengqim at linux.vnet.ibm.com
Thu Sep 25 13:51:56 UTC 2014


On Thu, Sep 25, 2014 at 11:40:11AM +0200, Daniele Venzano wrote:
> 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.

Ah, that is something worth a try.  Thanks.

Regards,
 Qiming
 
> Best,
> Daniele
> 
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
> 




More information about the OpenStack-dev mailing list