[
https://issues.apache.org/jira/browse/PHOENIX-3218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15469745#comment-15469745
]
Sumit Nigam commented on PHOENIX-3218:
--------------------------------------
Thank you for this good initiative. I have some queries/ suggestions:
In improving parallelization, you mentioned:
*Turn on stats, should improve it*
I thought stats are turned ON by default. Is that not correct?
Plus, I could not understand the following recommendation in the document:
*Configure stats to use small pipe size, creates even more stats*
Did you mean having lesser sized guideposts by reducing value of
phoenix.stats.guidepost.width from default 100Mb?
Lastly, using the IncreasingToUpperBoundRegionSplitPolicy (default) causes
first region split at 128Mb. Is phoenix.stats.guidepost.width (100M) a good
value or should it ideally be reduced from beginning itself given it is almost
same as region size?
We can also mention in the document that if we are reducing the size of the
guideposts, then phoenix.query.queueSize may need increasing as more work will
be queued thereafter.
> First draft of Phoenix Tuning Guide
> -----------------------------------
>
> Key: PHOENIX-3218
> URL: https://issues.apache.org/jira/browse/PHOENIX-3218
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Peter Conrad
> Attachments: Phoenix-Tuning-Guide.md
>
>
> Here's a first draft of a Tuning Guide for Phoenix performance.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
