You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Tamas Monos <ta...@veber.co.uk> on 2014/01/02 13:12:37 UTC
Usage records
Dear Cloudstack developers,
I am wondering what would be the impact on CloudStack if I run the following SQL statement on the usage database:
#delete from cloud_usage where start_date like "2012-%" AND end_date like "2012-%";
I am planning to remove lots of records that are no longer needed. Just really want to understand the impact of it.
As far as I believe if I will not ask for 2012 usage record anymore there is no impact at all.
Regards,
Tamas
Re: Usage records
Posted by Wei ZHOU <us...@gmail.com>.
yes. You can delete old records (please keep the latest records).
2014/1/2 Tamas Monos <ta...@veber.co.uk>
> Hi,
>
> In the usage_network table I only see "event_time_millis" no start/end.
> Can I assume that field is the timestamp?
>
> Thanks,
>
> Tamas
>
> -----Original Message-----
> From: Wei ZHOU [mailto:ustcweizhou@gmail.com]
> Sent: 02 January 2014 12:29
> To: dev@cloudstack.apache.org
> Subject: Re: Usage records
>
> no impact, I think.
> and usage_network table as well.
>
>
> 2014/1/2 Tamas Monos <ta...@veber.co.uk>
>
> > Dear Cloudstack developers,
> >
> > I am wondering what would be the impact on CloudStack if I run the
> > following SQL statement on the usage database:
> >
> > #delete from cloud_usage where start_date like "2012-%" AND end_date
> > like "2012-%";
> >
> > I am planning to remove lots of records that are no longer needed.
> > Just really want to understand the impact of it.
> > As far as I believe if I will not ask for 2012 usage record anymore
> > there is no impact at all.
> >
> > Regards,
> >
> > Tamas
> >
>
RE: Usage records
Posted by Tamas Monos <ta...@veber.co.uk>.
Hi,
In the usage_network table I only see "event_time_millis" no start/end.
Can I assume that field is the timestamp?
Thanks,
Tamas
-----Original Message-----
From: Wei ZHOU [mailto:ustcweizhou@gmail.com]
Sent: 02 January 2014 12:29
To: dev@cloudstack.apache.org
Subject: Re: Usage records
no impact, I think.
and usage_network table as well.
2014/1/2 Tamas Monos <ta...@veber.co.uk>
> Dear Cloudstack developers,
>
> I am wondering what would be the impact on CloudStack if I run the
> following SQL statement on the usage database:
>
> #delete from cloud_usage where start_date like "2012-%" AND end_date
> like "2012-%";
>
> I am planning to remove lots of records that are no longer needed.
> Just really want to understand the impact of it.
> As far as I believe if I will not ask for 2012 usage record anymore
> there is no impact at all.
>
> Regards,
>
> Tamas
>
Re: Usage records
Posted by Wei ZHOU <us...@gmail.com>.
no impact, I think.
and usage_network table as well.
2014/1/2 Tamas Monos <ta...@veber.co.uk>
> Dear Cloudstack developers,
>
> I am wondering what would be the impact on CloudStack if I run the
> following SQL statement on the usage database:
>
> #delete from cloud_usage where start_date like "2012-%" AND end_date like
> "2012-%";
>
> I am planning to remove lots of records that are no longer needed. Just
> really want to understand the impact of it.
> As far as I believe if I will not ask for 2012 usage record anymore there
> is no impact at all.
>
> Regards,
>
> Tamas
>