futuregrid / cloud-metrics

Project to create usage statistics from IaaS such as OpenStack, Eucalyptus, and Nimbus
2 stars 3 forks source link

Optimizing mysql queries #54

Open lee212 opened 11 years ago

lee212 commented 11 years ago

Just for the record, mysql queries take some time to be loaded. Optimizing queries would be considered by creating mysql Indexes. instance table has .12 million rows. It now has join queries with the cloudplatform table recently added as a reference of cloud platforms such as nimbus, eucalyptus, and openstack.