[ https://issues.apache.org/jira/browse/CLOUDSTACK-9340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279478#comment-15279478 ]
ASF subversion and git services commented on CLOUDSTACK-9340: ------------------------------------------------------------- Commit ccf226546007a82594866c82cd4f279758bb91d9 in cloudstack's branch refs/heads/master from [~williamstev...@gmail.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=ccf2265 ] Merge pull request #1466 from nvazquez/graldboptimization CLOUDSTACK-9340: General DB Optimization## Description 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) * pr/1466: CLOUDSTACK-9340: General DB Optimization Signed-off-by: Will Stevens <williamstev...@gmail.com> > 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)