GitHub user nvazquez opened a pull request:
https://github.com/apache/cloudstack/pull/1466
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)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/nvazquez/cloudstack graldboptimization
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/cloudstack/pull/1466.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 #1466
----
commit 248677437ac8d1369bf353683a64b21c613a62e7
Author: nvazquez <nicolas.m.vazq...@gmail.com>
Date: 2016-04-07T18:20:48Z
CLOUDSTACK-9340: General DB Optimization
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
