GitHub user nvazquez reopened 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 fa0e61f183b361f4544dd2904da53380c1e12cfe
Author: nvazquez <nicolas.m.vazq...@gmail.com>
Date: 2016-04-08T17:47:50Z
Dummy commit for testing travis
----
---
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.
---
