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

Chao Wang commented on PHOENIX-5971:
------------------------------------

Pass performance test, and analysis configuration. find a configuration 
influence. phoenix.mutate.batchSize.

this configuration from 1000 to 100 in 4.13.1.  batch size smaller, batch more 
and more, hbase rpc increase. and then block rpc request. so triple performance 
reduction.

I think we should set phoenix.mutate.batchSize in hbase-site.xml according to 
use scenario. if  you need large writing operation, you set 
phoenix.mutate.batchSize large.

> Triple performance reduction of delete operation from 4.4.0 Upgrade to 4.13.1
> -----------------------------------------------------------------------------
>
>                 Key: PHOENIX-5971
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5971
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.13.1
>         Environment: 200+ node
>            Reporter: Chao Wang
>            Priority: Major
>
> phoenix from 4.4.0 Upgrade to 4.13.1 in my environmental, delete operation 
> triple performance reduction. for example a sql (delete  ...  from ...) will 
> delete million of data, and then hundreds of concurrent. 



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

Reply via email to