[ https://issues.apache.org/jira/browse/CLOUDSTACK-8606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14611563#comment-14611563 ]
ASF GitHub Bot commented on CLOUDSTACK-8606: -------------------------------------------- GitHub user koushik-das opened a pull request: https://github.com/apache/cloudstack/pull/553 CLOUDSTACK-8606: DB performance impacted due to VM sync. VM sync. generates a lot of queries on vm_instance table with 'instance_name' as filter. Since the field is not indexed, these kind of queries will impact DB performance. Added an index for instance_name field. You can merge this pull request into a Git repository by running: $ git pull https://github.com/koushik-das/cloudstack CLOUDSTACK-8606 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/cloudstack/pull/553.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #553 ---- commit 47e005db533cbd9b2e40efc0adb276b677e228e2 Author: Koushik Das <kous...@apache.org> Date: 2015-07-02T06:41:53Z CLOUDSTACK-8606: DB performance impacted due to VM sync. VM sync. generates a lot of queries on vm_instance table with 'instance_name' as filter. Since the field is not indexed, these kind of queries will impact DB performance. Added an index for instance_name field. ---- > DB performance impacted due to VM sync. > --------------------------------------- > > Key: CLOUDSTACK-8606 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8606 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Management Server, Upgrade > Affects Versions: 4.5.0 > Reporter: Koushik Das > Assignee: Koushik Das > Fix For: 4.6.0 > > > VM sync. generates a lot of queries on vm_instance table with 'instance_name' > as filter. Since the field is not > indexed, these kind of queries will impact DB performance. > The issue is visible with deployments having more than 4000 VMs. VM sync. > runs every 'ping.interval' and in each run generates individual queries for > all VMs. If the MS is left running for a few hours, its response deteriorates > drastically. -- This message was sent by Atlassian JIRA (v6.3.4#6332)