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