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:[email protected]] 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)
