You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by psjia <ps...@travelsky.com> on 2012/10/29 03:40:24 UTC
vm_instance_id
Hello:
what is the mean of usage_type in cloud_usage.usage_vm_instance。
I noticed that the same vm_instance_id have two differents usage_type。for example:
mysql> select usage_type,zone_id,account_id,vm_instance_id,vm_name,start_date,end_date from cloud_usage.usage_vm_instance where vm_instance_id=3;
+------------+---------+------------+----------------+-------------+---------------------+---------------------+
| usage_type | zone_id | account_id | vm_instance_id | vm_name | start_date | end_date |
+------------+---------+------------+----------------+-------------+---------------------+---------------------+
| 1 | 1 | 2 | 3 | vm1-win2003 | 2012-09-11 03:59:35 | 2012-09-13 10:38:36 |
| 2 | 1 | 2 | 3 | vm1-win2003 | 2012-09-11 03:54:04 | 2012-09-13 10:45:00 |
+------------+---------+------------+----------------+-------------+---------------------+---------------------+
2 rows in set (0.00 sec)
RE: vm_instance_id
Posted by Mice Xia <mi...@tcloudcomputing.com>.
For usage_types:
RUNNING_VM =1
ALLOCATED_VM=2
RUNNING_VM tracks the time span between EVENT_VM_START and EVENT_VM_STOP
ALLOCATED_VM tracks the time span between EVENT_VM_CREATE AND EVENT_VM_DESTROY
Regards
Mice
-----Original Message-----
From: psjia [mailto:psjia@travelsky.com]
Sent: Monday, October 29, 2012 10:40 AM
To: cloudstack-users
Subject: vm_instance_id
Hello:
what is the mean of usage_type in cloud_usage.usage_vm_instance。
I noticed that the same vm_instance_id have two differents usage_type。for example:
mysql> select usage_type,zone_id,account_id,vm_instance_id,vm_name,start_date,end_date from cloud_usage.usage_vm_instance where vm_instance_id=3;
+------------+---------+------------+----------------+-------------+---------------------+---------------------+
| usage_type | zone_id | account_id | vm_instance_id | vm_name | start_date | end_date |
+------------+---------+------------+----------------+-------------+---------------------+---------------------+
| 1 | 1 | 2 | 3 | vm1-win2003 | 2012-09-11 03:59:35 | 2012-09-13 10:38:36 |
| 2 | 1 | 2 | 3 | vm1-win2003 | 2012-09-11 03:54:04 | 2012-09-13 10:45:00 |
+------------+---------+------------+----------------+-------------+---------------------+---------------------+
2 rows in set (0.00 sec)