Misty Stanley-Jones created HBASE-11985:
-------------------------------------------

             Summary: Document sizing rules of thumb
                 Key: HBASE-11985
                 URL: https://issues.apache.org/jira/browse/HBASE-11985
             Project: HBase
          Issue Type: Task
          Components: documentation
            Reporter: Misty Stanley-Jones
            Assignee: Misty Stanley-Jones


I'm looking for tuning/sizing rules of thumb to put in the Ref Guide.

Info I have gleaned so far:

A reasonable region size is between 10 GB and 50 GB.

A reasonable maximum cell size is 1 MB to 10 MB. If your cells are larger than 
10 MB, consider storing the cell contents in HDFS and storing a reference to 
the location in HBase. Pending MOB work for 10 MB - 64 MB window.

When you size your regions and cells, keep in mind that a region cannot split 
across a row. If your row size is too large, or your region size is too small, 
you can end up with a single row per region, which is not a good pattern. It is 
also possible that one big column causes splits while other columns are tiny, 
and this may not be great.

A large # of columns probably means you are doing it wrong.

Column names need to be short because they get stored for every value (barring 
encoding). Don't need to be self-documenting like in RDBMS.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to