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:42 UTC

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

Repository: cloudstack
Updated Branches:
  refs/heads/master e5f0788ed -> 476e9f021


CLOUDSTACK-8300: Set indexes on event table


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

Branch: refs/heads/master
Commit: 14c837ab8329f98b3fe071dd69807dcae77f4f7c
Parents: e5f0788
Author: Remi Bergsma <gi...@remi.nl>
Authored: Sat Jan 30 16:50:46 2016 +0100
Committer: Remi Bergsma <gi...@remi.nl>
Committed: Sat Jan 30 16:50:46 2016 +0100

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


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/14c837ab/setup/db/db/schema-481to490.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-481to490.sql b/setup/db/db/schema-481to490.sql
index c80fa2a..0f27e45 100644
--- a/setup/db/db/schema-481to490.sql
+++ b/setup/db/db/schema-481to490.sql
@@ -18,3 +18,6 @@
 --;
 -- Schema upgrade from 4.8.1 to 4.9.0;
 --;
+
+ALTER TABLE `event` ADD INDEX `archived` (`archived`);
+ALTER TABLE `event` ADD INDEX `state` (`state`);


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

Posted by re...@apache.org.
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(+)
----------------------------------------------------------------------