cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sw...@apache.org
Subject [2/2] git commit: updated refs/heads/master to ccf2265
Date Wed, 11 May 2016 03:58:00 GMT
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 <williamstevens@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/master
Commit: ccf226546007a82594866c82cd4f279758bb91d9
Parents: 726ee47 8b6e618
Author: Will Stevens <williamstevens@gmail.com>
Authored: Tue May 10 23:57:39 2016 -0400
Committer: Will Stevens <williamstevens@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(+)
----------------------------------------------------------------------



Mime
View raw message