You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cloudstack.apache.org by re...@apache.org on 2016/01/31 18:59:43 UTC

[2/2] git commit: updated refs/heads/master to 476e9f0

Merge pull request #1387 from remibergsma/CLOUDSTACK-8300

CLOUDSTACK-8300: Set indexes on event tableWhen there are many events in the cloud.event table, the UI throws an SQL exception and the management server spikes at 100% CPU for minutes. That causes other API calls to fail with 530 errors.

It seems an index on the 'archived' field is missing (since it is used in the WHERE clause).

We have 1.4M events in the table:
`select count(*) from event;`
1497838

This PR adds the index to the `archived` field and the `state` field.

* pr/1387:
  CLOUDSTACK-8300: Set indexes on event table

Signed-off-by: Remi Bergsma <gi...@remi.nl>


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/476e9f02
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/476e9f02
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/476e9f02

Branch: refs/heads/master
Commit: 476e9f02106de945746e6f5a6e1cd716d6d3c010
Parents: e5f0788 14c837a
Author: Remi Bergsma <gi...@remi.nl>
Authored: Sun Jan 31 18:59:23 2016 +0100
Committer: Remi Bergsma <gi...@remi.nl>
Committed: Sun Jan 31 18:59:23 2016 +0100

----------------------------------------------------------------------
 setup/db/db/schema-481to490.sql | 3 +++
 1 file changed, 3 insertions(+)
----------------------------------------------------------------------