[
https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16335989#comment-16335989
]
Attila Sasvari commented on OOZIE-1717:
---------------------------------------
I can imagine adding index on the created_time column of COORD_JOBS , could
help too (a lot of coordinator jobs might be created). I saw this in slow
query log when going through the coordinator jobs:
{code:java}
SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name,
t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency,
t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone,
t0.time_out, t0.bundle_id FROM COORD_JOBS t0 WHERE ((t0.status = 'RUNNING' OR
t0.status = 'PREP' OR t0.status = 'SUSPENDED' OR t0.status = 'RUNNINGWITHERROR'
OR t0.status = 'PREPSUSPENDED' OR t0.status = 'SUSPENDEDWITHERROR' OR t0.status
= 'PREPPAUSED' OR t0.status = 'PAUSED' OR t0.status = 'PAUSEDWITHERROR') AND
t0.status IS NOT NULL) ORDER BY t0.created_time DESC LIMIT 100, 100;{code}
> Index user_name column
> ----------------------
>
> Key: OOZIE-1717
> URL: https://issues.apache.org/jira/browse/OOZIE-1717
> Project: Oozie
> Issue Type: Bug
> Reporter: Purshotam Shah
> Assignee: Attila Sasvari
> Priority: Minor
> Attachments: OOZIE-1717-00.patch
>
>
> User_name is one of the frequently used filter. Adding index should avoid
> full db scan.
> Index need to be done for BUNDLE_JOBS,COORD_JOBS and WF_JOBS.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
