Hi. I need to provide the usage data to my developers, but there seems to be almost no data inside mysql tables for cloud_usage database.
Is this the normal behavior - please note that the original installation was 4.0.0, then we upgraded to 4.2... Jan 10.2013 is the date when the cloudstack (4.0.0) was installed originaly. Only few of the tables have been updated since then... Global parameter to enable usage server is also set to "true", default GMT time zone, etc.. Service also running etc.. Am I missing something ? Thanks [root@cs1 ~]# ll /var/lib/mysql/cloud_usage/ total 11940 -rw-rw---- 1 mysql mysql 9077 Oct 21 2013 account.frm -rw-rw---- 1 mysql mysql 180224 Apr 30 18:16 account.ibd -rw-rw---- 1 mysql mysql 13384 Oct 21 2013 cloud_usage.frm -rw-rw---- 1 mysql mysql 163840 Oct 21 2013 cloud_usage.ibd -rw-rw---- 1 mysql mysql 61 Jan 10 2013 db.opt -rw-rw---- 1 mysql mysql 9044 Oct 21 2013 usage_event.frm -rw-rw---- 1 mysql mysql 9437184 Apr 30 18:16 usage_event.ibd -rw-rw---- 1 mysql mysql 8894 Jan 10 2013 usage_ip_address.frm -rw-rw---- 1 mysql mysql 147456 Jan 10 2013 usage_ip_address.ibd -rw-rw---- 1 mysql mysql 9267 Jan 10 2013 usage_job.frm -rw-rw---- 1 mysql mysql 163840 May 1 00:18 usage_job.ibd -rw-rw---- 1 mysql mysql 8746 Jan 10 2013 usage_load_balancer_policy.frm -rw-rw---- 1 mysql mysql 147456 Jan 10 2013 usage_load_balancer_policy.ibd -rw-rw---- 1 mysql mysql 8982 Jan 10 2013 usage_network.frm -rw-rw---- 1 mysql mysql 98304 Jan 10 2013 usage_network.ibd -rw-rw---- 1 mysql mysql 8906 Oct 21 2013 usage_network_offering.frm -rw-rw---- 1 mysql mysql 147456 Oct 21 2013 usage_network_offering.ibd -rw-rw---- 1 mysql mysql 8746 Jan 10 2013 usage_port_forwarding.frm -rw-rw---- 1 mysql mysql 147456 Jan 10 2013 usage_port_forwarding.ibd -rw-rw---- 1 mysql mysql 8826 Jan 10 2013 usage_security_group.frm -rw-rw---- 1 mysql mysql 147456 Jan 10 2013 usage_security_group.ibd -rw-rw---- 1 mysql mysql 8908 Oct 21 2013 usage_storage.frm -rw-rw---- 1 mysql mysql 147456 Oct 21 2013 usage_storage.ibd -rw-rw---- 1 mysql mysql 9088 Oct 21 2013 usage_vm_disk.frm -rw-rw---- 1 mysql mysql 98304 Oct 21 2013 usage_vm_disk.ibd -rw-rw---- 1 mysql mysql 8972 Jan 10 2013 usage_vm_instance.frm -rw-rw---- 1 mysql mysql 163840 Jan 10 2013 usage_vm_instance.ibd -rw-rw---- 1 mysql mysql 8866 Oct 21 2013 usage_vmsnapshot.frm -rw-rw---- 1 mysql mysql 114688 Oct 21 2013 usage_vmsnapshot.ibd -rw-rw---- 1 mysql mysql 8874 Jan 10 2013 usage_volume.frm -rw-rw---- 1 mysql mysql 147456 Jan 10 2013 usage_volume.ibd -rw-rw---- 1 mysql mysql 8796 Jan 10 2013 usage_vpn_user.frm -rw-rw---- 1 mysql mysql 147456 Jan 10 2013 usage_vpn_user.ibd -rw-rw---- 1 mysql mysql 9170 Jan 10 2013 user_statistics.frm -rw-rw---- 1 mysql mysql 131072 Apr 30 18:16 user_statistics.ibd -rw-rw---- 1 mysql mysql 9328 Oct 21 2013 vm_disk_statistics.frm -rw-rw---- 1 mysql mysql 262144 Apr 30 18:16 vm_disk_statistics.ibd [root@cs1 ~]# service cloudstack-usage status cloudstack-usage (pid 2324) is running... [root@cs1 ~]# rpm -qa | grep -i cloudstack cloudstack-awsapi-4.2.1-1.el6.x86_64 cloudstack-common-4.2.1-1.el6.x86_64 cloudstack-agent-4.2.1-1.el6.x86_64 cloudstack-management-4.2.1-1.el6.x86_64 cloudstack-usage-4.2.1-1.el6.x86_64 -- Andrija Panić -------------------------------------- http://admintweets.com --------------------------------------
