You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by bh...@apache.org on 2016/05/11 09:43:20 UTC
[32/50] [abbrv] git commit: updated refs/heads/4.9-bountycastle-daan
to 4817cb6
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 <wi...@gmail.com>
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/ccf22654
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/ccf22654
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/ccf22654
Branch: refs/heads/4.9-bountycastle-daan
Commit: ccf226546007a82594866c82cd4f279758bb91d9
Parents: 726ee47 8b6e618
Author: Will Stevens <wi...@gmail.com>
Authored: Tue May 10 23:57:39 2016 -0400
Committer: Will Stevens <wi...@gmail.com>
Committed: Tue May 10 23:57:39 2016 -0400
----------------------------------------------------------------------
setup/db/db/schema-481to490-cleanup.sql | 65 ++++++++++++++++++++++++++++
setup/db/db/schema-481to490.sql | 23 ++++++++++
2 files changed, 88 insertions(+)
----------------------------------------------------------------------