You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by "sdhalex (Jira)" <ji...@apache.org> on 2019/12/22 13:11:00 UTC

[jira] [Commented] (RANGER-2149) REST search queries make Ranger incredibly slow

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

sdhalex commented on RANGER-2149:
---------------------------------

Excuse me, is it really a mysql 5.1 issue?   has this bug been fixed in the newest version?  Or need we still do the same workaround to avoid this bug now ? Thx.  [~pradeep]   [~aposledov]

> REST search queries make Ranger incredibly slow 
> ------------------------------------------------
>
>                 Key: RANGER-2149
>                 URL: https://issues.apache.org/jira/browse/RANGER-2149
>             Project: Ranger
>          Issue Type: Bug
>          Components: Ranger
>    Affects Versions: 0.7.0
>            Reporter: Alexander Posledov
>            Assignee: Pradeep Agrawal
>            Priority: Major
>         Attachments: bulkpolicytest.png, totalPolicy.png
>
>
> If amount of Ranger policies is relatively big (3000-4000), then REST search queries (e.g. search policy by name) make Ranger very slow. Example:
> curl -u admin:admin -X GET http://host:6080/service/plugins/policies?policyName=somePolicyName
> 2-3 such queries (if we have ~3k policies) can cause too long delays even for simple requests, while these searches aren't completed. In some cases, when we ran several search queries simultaneously, this Ranger behavior caused 9 min delay for simple adding a new policy.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)