[
https://issues.apache.org/jira/browse/PHOENIX-3218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15450527#comment-15450527
]
James Taylor commented on PHOENIX-3218:
---------------------------------------
Thanks for putting this together, [~pconrad]. I think it'd be useful to have a
single guide for tuning that has pointers out to other reference material, as
it's difficult for users to know where to look for this information (since it's
scattered throughout). This is a good first step.
Here's some specific feedback:
- Given that primary key design is the most important factor, I think the guide
should lead with that. Might need to be expanded too - there've been several
really good presentations in the past on this (i.e. [~ivarley] did one a few
years back).
{code}
## Primary Keys
The underlying row key design is the single most important factor in Phoenix
performance, and it's important to get it right at design time because you
can't patch it later.
{code}
- To help users understand this, I think one or more examples or use cases
should be used throughout the guide. This will help users relate more to the
information presented and see what changes need to be made for each topic.
- For the write-heavy section, you mention using HBase or Phoenix compression.
Minor nit, but Phoenix provides no compression - we get that goodness directly
from HBase. Also, compression is good across the board, both for reading and
writing, because it reduces disk IO. I'd recommend calling that out independent
of this section (maybe you already do?).
{code}
* For write-heavy data:
* Turn on HBase or Phoenix compression.
{code}
- In the Improving parallelization section, can you add a link to
https://phoenix.apache.org/update_statistics.html
{code}
## Improving parallelization
Given a region, what HBase knows is the start key and the key in the next
region (the end key kind of)
{code}
- In general, more links into the HBase Reference Guide would be useful:
https://hbase.apache.org/book.html
> 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)
