Greenplum Command Center Parameters
Configuration parameters for Pivotal Greenplum Command Center are stored in the following files on the Greenplum Database Master host:
Any system user with write permissions to these directories can edit these configuration files. After editing any of these files, apply the configuration changes by restarting Command Center.
$ gpcc --start
Command Center Parameters (app.conf)
app.conf file includes the following web application parameters:
pg_hba.conffile using the trust authentication method. When set to yes, trusted database users are allowed to login to Command Center without a password. By default, this parameter is commented out. See the Greenplum Database Administrator Guide for more information about the
Gpperfmon Agent Parameters
$MASTER_DATA_DIRECTORY/gpperfmon/conf/gpperfmon.conf file on the Greenplum Database master host stores configuration parameters for the gpperfmon agents,
gpsmon. After editing this file, save
gpperfmon.conf and then restart Greenplum Database:
$ gpstop -r
If you want a less granular view of performance, or you want to collect and analyze minimal amounts of data for system metrics, specify a higher quantum. To collect data more frequently, enter a lower value.
queries_historytable. For queries with shorter run times, no historical data is collected. Defaults to 20 seconds.
If you want to collect data for all queries, 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 might not be useful.
To prevent the log files from becoming excessive in 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 starts a new log file.
This optional fault tolerance parameter is useful if the 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.
Greenplum Command Center Console Parameters
These parameters only apply to the Greenplum Data Computing Appliance platform.
The Command Center Console has a configuration file located at
After editing this file, reload the configuration by restarting the Command Center:
$ gpcc --stop $ gpcc --start
Greenplum Database Server Configuration Parameters
The following parameters must be uncommented and set in the server configuration file (
postgresql.conf) in order to enable the gpperfmon data collection agents. With the exception of
gp_enable_gpperfmon, these parameters are set in the master
postgresql.conf file only. Restart Greenplum Database to apply any changes you make to this file.
postgresql.conffiles (master and all segments).