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-9340) General DB Optimization
Date Fri, 08 Apr 2016 21:40:25 GMT

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

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

Github user bhaisaab commented on the pull request:

    https://github.com/apache/cloudstack/pull/1466#issuecomment-207617920
  
    @swill @nvazquez I saw the failing job: https://travis-ci.org/apache/cloudstack/jobs/121766436
    It failed due to missing Marvin distribution:
    IOError: [Errno 2] No such file or directory: '/home/travis/build/apache/cloudstack/tools/marvin/dist/Marvin-*.tar.gz'
    
    The actual error seems to be hidden as only parts of mvn build output are shown in the
output. It is likely that one of the unit tests have failed (likely one unit test related
to kvm disk i/o where it checks some disk activity -- this has happened in my VM env few time
though does not happen on baremetal). 
    
    I'll open a PR to increase verbosity of the Travis build to output which test/module failed.


> General DB Optimization
> -----------------------
>
>                 Key: CLOUDSTACK-9340
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9340
>             Project: CloudStack
>          Issue Type: Improvement
>      Security Level: Public(Anyone can view this level - this is the default.) 
>    Affects Versions: 4.9.0
>            Reporter: Nicolas Vazquez
>              Labels: database
>             Fix For: 4.9.0
>
>
> h2. General DB Optimization
> In some production environments there were being experimented delays in most of the jobs.
A search for DB optimization was taken and some deficiencies were discovered, we can group
them in 4 groups:
> * Incorrect PRIMARY key
> * Duplicate PRIMARY KEY
> * Missing indexes (Add indexes to avoid full table scans)
> * Some views query (Change view to improve account retrieval speed)



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

Mime
View raw message