You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by Attila Sasvari via Review Board <no...@reviews.apache.org> on 2018/02/05 09:52:40 UTC
Re: Review Request 65385: OOZIE-1717 add indices to speed up db
queries
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/65385/
-----------------------------------------------------------
(Updated Feb. 5, 2018, 9:52 a.m.)
Review request for oozie.
Repository: oozie-git
Description
-------
Add indices to speed up SELECT operations.
Index user_name column
for purge service OOZIE-1803:
CREATE INDEX "OOZIEDB"."BUNDLE_JOBS_END_TIME_IDX" ON "BUNDLE_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."COORD_JOBS_END_TIME_IDX" ON "COORD_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."WF_JOBS_END_TIME_IDX" ON "WF_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."COORD_ACTIONS_JOB_ID_IDX" ON "COORD_ACTIONS" ("JOB_ID");
CREATE INDEX "OOZIEDB"."COORD_JOBS_BUNDLE_ID_IDX" ON "COORD_JOBS" ("BUNDLE_ID");
CREATE INDEX "OOZIEDB"."WF_ACTIONS_WF_ID_IDX" ON "WF_ACTIONS" ("WF_ID");
CREATE INDEX "OOZIEDB"."WF_JOBS_PARENT_ID_IDX" ON "WF_JOBS" ("PARENT_ID");
CREATE INDEX "OOZIEDB"."BUNDLE_ACTIONS_BUNDLE_ID_IDX" ON "BUNDLE_ACTIONS" ("BUNDLE_ID");
Composite indices to speed up operations on the web UI
Diffs (updated)
-----
core/src/main/java/org/apache/oozie/BundleJobBean.java b42f12841c2f9cb6d508cd2ac2f393e6407d1cf0
core/src/main/java/org/apache/oozie/CoordinatorJobBean.java 99c7d3c474d9e1e22e2f5a927c03d71b9292b663
core/src/main/java/org/apache/oozie/WorkflowJobBean.java cd9a6df42e552a0607606a244b81978747d89b41
tools/src/main/java/org/apache/oozie/tools/OozieDBCLI.java a8b2234966c967f9ad9d722628bd486012b14bd3
Diff: https://reviews.apache.org/r/65385/diff/3/
Changes: https://reviews.apache.org/r/65385/diff/2-3/
Testing
-------
Thanks,
Attila Sasvari
Re: Review Request 65385: OOZIE-1717 add indices to speed up db
queries
Posted by Attila Sasvari via Review Board <no...@reviews.apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/65385/
-----------------------------------------------------------
(Updated Feb. 6, 2018, 1 a.m.)
Review request for oozie.
Changes
-------
verify indexes - create, upgrade db
Repository: oozie-git
Description
-------
Add indices to speed up SELECT operations.
Index user_name column
for purge service OOZIE-1803:
CREATE INDEX "OOZIEDB"."BUNDLE_JOBS_END_TIME_IDX" ON "BUNDLE_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."COORD_JOBS_END_TIME_IDX" ON "COORD_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."WF_JOBS_END_TIME_IDX" ON "WF_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."COORD_ACTIONS_JOB_ID_IDX" ON "COORD_ACTIONS" ("JOB_ID");
CREATE INDEX "OOZIEDB"."COORD_JOBS_BUNDLE_ID_IDX" ON "COORD_JOBS" ("BUNDLE_ID");
CREATE INDEX "OOZIEDB"."WF_ACTIONS_WF_ID_IDX" ON "WF_ACTIONS" ("WF_ID");
CREATE INDEX "OOZIEDB"."WF_JOBS_PARENT_ID_IDX" ON "WF_JOBS" ("PARENT_ID");
CREATE INDEX "OOZIEDB"."BUNDLE_ACTIONS_BUNDLE_ID_IDX" ON "BUNDLE_ACTIONS" ("BUNDLE_ID");
Composite indices to speed up operations on the web UI
Diffs (updated)
-----
tools/src/main/java/org/apache/oozie/tools/OozieDBCLI.java 4bb6dd8606784fc0c4eb7aaedef79c59617f65eb
Diff: https://reviews.apache.org/r/65385/diff/5/
Changes: https://reviews.apache.org/r/65385/diff/4-5/
Testing
-------
Thanks,
Attila Sasvari
Re: Review Request 65385: OOZIE-1717 add indices to speed up db
queries
Posted by Peter Cseh via Review Board <no...@reviews.apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/65385/#review196803
-----------------------------------------------------------
Ship it!
Ship It!
- Peter Cseh
On Feb. 5, 2018, 9:52 a.m., Attila Sasvari wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/65385/
> -----------------------------------------------------------
>
> (Updated Feb. 5, 2018, 9:52 a.m.)
>
>
> Review request for oozie.
>
>
> Repository: oozie-git
>
>
> Description
> -------
>
> Add indices to speed up SELECT operations.
>
>
> Index user_name column
>
> for purge service OOZIE-1803:
> CREATE INDEX "OOZIEDB"."BUNDLE_JOBS_END_TIME_IDX" ON "BUNDLE_JOBS" ("END_TIME");
> CREATE INDEX "OOZIEDB"."COORD_JOBS_END_TIME_IDX" ON "COORD_JOBS" ("END_TIME");
> CREATE INDEX "OOZIEDB"."WF_JOBS_END_TIME_IDX" ON "WF_JOBS" ("END_TIME");
> CREATE INDEX "OOZIEDB"."COORD_ACTIONS_JOB_ID_IDX" ON "COORD_ACTIONS" ("JOB_ID");
> CREATE INDEX "OOZIEDB"."COORD_JOBS_BUNDLE_ID_IDX" ON "COORD_JOBS" ("BUNDLE_ID");
> CREATE INDEX "OOZIEDB"."WF_ACTIONS_WF_ID_IDX" ON "WF_ACTIONS" ("WF_ID");
> CREATE INDEX "OOZIEDB"."WF_JOBS_PARENT_ID_IDX" ON "WF_JOBS" ("PARENT_ID");
> CREATE INDEX "OOZIEDB"."BUNDLE_ACTIONS_BUNDLE_ID_IDX" ON "BUNDLE_ACTIONS" ("BUNDLE_ID");
>
> Composite indices to speed up operations on the web UI
>
>
> Diffs
> -----
>
> core/src/main/java/org/apache/oozie/BundleJobBean.java b42f12841c2f9cb6d508cd2ac2f393e6407d1cf0
> core/src/main/java/org/apache/oozie/CoordinatorJobBean.java 99c7d3c474d9e1e22e2f5a927c03d71b9292b663
> core/src/main/java/org/apache/oozie/WorkflowJobBean.java cd9a6df42e552a0607606a244b81978747d89b41
> tools/src/main/java/org/apache/oozie/tools/OozieDBCLI.java a8b2234966c967f9ad9d722628bd486012b14bd3
>
>
> Diff: https://reviews.apache.org/r/65385/diff/3/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Attila Sasvari
>
>