Command Center Agent Parameters
The $MASTER_DATA_DIRECTORY/gpperfmon/conf/gpperfmon.conf
file on the Greenplum Database master host stores configuration parameters for the Command Center agents. For configuration changes to these options to take effect, you must save gpperfmon.conf
and then restart Greenplum Database server (gpstop -r
).
To enable the Command Center agents within Greenplum Database server, you must also set the Greenplum Database Server Configuration Parameters. See the gpperfmon_install
reference in the Greenplum Database Utility Guide for details.
$MASTER_DATA_DIRECTORY/gpperfmon/logs
.
If you know that you want to collect data for all queries, you can set this parameter to a low value. Setting the minimum query run time to zero, however, collects data even for the numerous queries run by Command Center itself, creating a large amount of data that may not be useful.
This parameter’s value must always be equal to, or greater than, the value of min_query_time
. Setting min_detailed_query_time
higher than min_query_time
allows you to log detailed query plan iterator data only for especially complex, long-running queries, while still logging basic query data for shorter queries.
Given the complexity and size of iterator data, you may want to adjust this parameter according to the size of data collected. If the iterators_*
tables are growing to excessive size without providing useful information, you can raise the value of this parameter to log iterator detail for fewer queries.
To prevent the log files from growing to excessive size, you can add the max_log_size
parameter to gpperfmon.conf
. The value of this parameter is measured in bytes. For example:
max_log_size = 10485760
With this setting, the log files will grow to 10MB before the system rolls over to a new log file.
If you prefer a less granular view of performance, or want to collect and analyze minimal amounts of data for system metrics, choose a higher quantum. To collect data more frequently, choose a lower value.
queries_*
tables: rows_out
, cpu_elapsed
, cpu_currpct
, skew_cpu
, and skew_rows
. The default setting, true, reduces the amount of memory consumed by the gpmmon process. Set this parameter to false if you require this additional performance data.
smdw_aliases= smdw-1,smdw-2
This optional fault tolerance parameter is useful if the Greenplum Command Center loses connectivity with the standby master. Instead of continuously retrying to connect to host smdw, it will try to connect to the NIC-based aliases of smdw-1
and/or smdw-2
. This ensures that the Command Center Console can continuously poll and monitor the standby master.