[jira] [Commented] (DRILL-5028) Opening profiles page from web ui gets very slow when a lot of history files have been stored in HDFS or Local FS.

["Kunal Khatua (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-5028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16290482#comment-16290482 ] 

Kunal Khatua commented on DRILL-5028:
-------------------------------------

This looks related to DRILL-5270 which has the same issue. I'm linking it for now, since DRILL-5270 attempts address this.

> Opening profiles page from web ui gets very slow when a lot of history files have been stored in HDFS or Local FS.
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-5028
>                 URL: https://issues.apache.org/jira/browse/DRILL-5028
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Functions - Drill
>    Affects Versions: 1.8.0
>            Reporter: Hongze Zhang
>            Priority: Minor
>             Fix For: Future
>
>
> We have a Drill cluster with 20+ Nodes and we store all history profiles in hdfs. Without doing periodically cleans for hdfs, the profiles page gets slower while serving more queries.
> Code from LocalPersistentStore.java uses fs.list(false, basePath) for fetching the latest 100 history profiles by default, I guess this operation blocks the page loading (Millions small files can be stored in the basePath), maybe we can try some other ways to reach the same goal.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)