[
https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16335934#comment-16335934
]
Attila Sasvari commented on OOZIE-1717:
---------------------------------------
[~gezapeti] thanks for the review, I will do such changes. I will also set "4"
for DB_VERSION_FOR_5_0 following existing pattern.
I ran some explain query for selects that appeared in slow query log of MariaDB
and after applying the new indices I saw that for example filesort was not used
anymore (proper index was used). Anyway, I want to load a really large database
and continue investigation (clicking though web UI and watching slow query-s).
It would be nice to have a list of the most frequent queries.
> 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)
