Configurations - Tuning

Cluster Size	Recommended Mode	Collector Heapsize ams-env : metrics_collector_heapsize	HBase Master Heapsize ams-hbase-env : hbase_master_heapsize	HBase RS Heapsize ams-hbase-env : hbase_regionserver_heapsize	HBase Master xmn size ams-hbase-env : hbase_master_xmn_size	HBase RS xmn size ams-hbase-env : regionserver_xmn_size
1 - 10	Embedded	512	1408	512	192	-
11 - 20	Embedded	1024	1920	512	256	-
21 - 100	Embedded	1664	5120	512	768	-
100 - 300	Embedded	4352	13056	512	2048	-
300 - 500	Distributed	4352	512	13056	102	2048
500 - 800	Distributed	7040	512	21120	102	3072
800 - 1000	Distributed	11008	512	32768	102	5120
1000+	Distributed	13696	512	32768	102	5120

Configuration	Property	Description	Minimum Recommended values (Host Count => MB)
ams-site	phoenix.query.maxGlobalMemoryPercentage	Percentage of total heap memory used by Phoenix threads in the Metrics Collector API/Aggregator daemon.	20 - 30, based on available memory. Default = 25.
ams-site	phoenix.spool.directory	Set directory for Phoenix spill files. (Client side)	Set this to different disk from hbase.rootdir dir if possible.
ams-hbase-site	phoenix.spool.directory	Set directory for Phoenix spill files. (Server side)	Set this to different disk from hbase.rootdir dir if possible.
ams-hbase-site	phoenix.query.spoolThresholdBytes	Threshold size in bytes after which results from parallelly executed query results are spooled to disk.	Set this to higher value based on available memory. Default is 12 mb.

Space shortcuts