cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicolas Vazquez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-9340) General DB Optimization
Date Thu, 07 Apr 2016 15:34:25 GMT
Nicolas Vazquez created CLOUDSTACK-9340:
-------------------------------------------

             Summary: 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
             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