cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-9298) Improve performance of resource retrieval that have tags associated and target volumes, VMs and templates
Date Thu, 10 Mar 2016 14:52:41 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-9298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15189386#comment-15189386
] 

ASF GitHub Bot commented on CLOUDSTACK-9298:
--------------------------------------------

Github user nvazquez commented on the pull request:

    https://github.com/apache/cloudstack/pull/1425#issuecomment-194884875
  
    Hi @rafaelweingartner @pedro-martins,
    
    I see continuous integration check is still failing due to this error, I made some changes
in <code>setup/db/db/schema-481to490.sql</code>:
    
    <code>[ERROR] Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.2.1:java
(create-schema) on project cloud-developer: An exception occured while executing the Java
class. null: InvocationTargetException: Unable to upgrade the database: Unable to execute
upgrade script: /home/travis/build/apache/cloudstack/developer/target/db/db/schema-481to490.sql:
Access denied; you need (at least one of) the SUPER privilege(s) for this operation ->
[Help 1]</code>


> Improve performance of resource retrieval that have tags associated and target volumes,
VMs and templates
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-9298
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9298
>             Project: CloudStack
>          Issue Type: Improvement
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: API
>    Affects Versions: 4.9.0
>            Reporter: Nicolas Vazquez
>             Fix For: 4.9.0
>
>
> h2. Description of the problem
> When retrieving a large number of resources which have tags associated with, retrieval
methods took too long. Our goal is to improve performance of this methods avoiding query the
database for each tag, managing that information in memory.
> API methods to improve: {{listTemplates}}, {{listVolumes}}, {{listVirtualMachines}}
> To achive it, it's necessary to include new columns in {{template_view}}, {{volume_view}}
and {{user_vm_view}}:
> * tag_account_name
> * tag_domain_name
> * tag_domain_uuid



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message