[
https://issues.apache.org/jira/browse/PHOENIX-1322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14161312#comment-14161312
]
James Taylor commented on PHOENIX-1322:
---------------------------------------
FYI, the stats name changed:
{code}
// Config parameters for stats collection
public static final String STATS_UPDATE_FREQ_MS_ATTRIB =
"phoenix.stats.updateFrequency";
public static final String MIN_STATS_UPDATE_FREQ_MS_ATTRIB =
"phoenix.stats.minUpdateFrequency";
public static final String STATS_GUIDEPOST_WIDTH_BYTES_ATTRIB =
"phoenix.stats.guidepost.width";
{code}
The phoenix.stats.minUpdateFrequency is the client-side param for the minimum
amount of time to wait before allowing an UPDATE STATISTICS to be called. The
phoenix.stats.updateFrequency is the server-side parameter for how often the
stats table is re-read to find the latest stats.
The defaults are:
{code}
public static final long DEFAULT_STATS_HISTOGRAM_DEPTH_BYTE = 1024 * 1024 *
30;
public static final int DEFAULT_STATS_UPDATE_FREQ_MS = 15 * 60000; // 15min
public static final int DEFAULT_MIN_STATS_UPDATE_FREQ_MS =
DEFAULT_STATS_UPDATE_FREQ_MS/2;
{code}
> Add documentation for UPDATE STATISTICS command
> -----------------------------------------------
>
> Key: PHOENIX-1322
> URL: https://issues.apache.org/jira/browse/PHOENIX-1322
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: ramkrishna.s.vasudevan
>
> Four places need to be updated:
> - Add a new webpage and add the webpage to the Using menu
> (/site/source/src/site/site.xml). The webpage can talk about the new ANALYZE
> <table> command and give a couple of examples. It'd be good to document that
> stats are updated automatically during splits and compaction. Also, mention
> the new property values you added to control - number of bytes before
> guidepost put in, min time before another analyze may be done. Don't talk
> about implementation, though, other than the "why" we're doing this (i.e. to
> improve parallelization).
> - Add the new ANALYZE call with a short explanation to
> ./phoenix-docs/src/docsrc/help/phoenix.csv. This will cause it to appear
> here: http://phoenix.apache.org/language/index.html
> - Add an item at the top for Statistics Collection with a short explanation
> here: site/source/src/site/markdown/recent.md
> - Remove the first item from Cost-based Query Optimization, or change the
> font to strike through with a note that it's implemented in 3.2/4.2) here:
> site/source/src/site/markdown/roadmap.md
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
