gpmemwatcher
gpmemwatcher
Tracks the memory usage of each process in a Greenplum Database cluster.
Synopsis
gpmemwatcher [-f | --host_file hostfile] gpmemwatcher --stop [-f | --host_file hostfile] gpmemwatcher --version gpmemwatcher -h | --help
Description
The gpmemwatcher utility is a daemon that runs on all servers of a Greenplum Database cluster. It tracks the memory usage of each process by collecting the output of the ps command every 60 seconds. It is a low impact process that only consumes 4 MB of memory. It will generate approximately 30 MB of data over a 24-hour period.
You may use this utility if Greenplum Database is reporting Out of memory errors and causing segments to go down or queries to fail. You collect the memory usage information of one or multiple servers within the Greenplum Database cluster with gpmemwatcher and then use gpmemreport to analyze the files collected.
Options
- -f | --host_file hostfile
- Indicates the hostfile input file that lists the hosts from which the
utility should collect memory usage information. The file must include the
hostnames and a working directory that exists on each one of the hosts. For
example:
mdw:/home/gpadmin/gpmemwatcher_dir/working sdw1:/home/gpadmin/gpmemwatcher_dir/working sdw2:/home/gpadmin/gpmemwatcher_dir/working sdw3:/home/gpadmin/gpmemwatcher_dir/working sdw4:/home/gpadmin/gpmemwatcher_dir/working
- --stop
- Stops all the gpmemwatcher processes, generates .gz data files in the current directory, and removes all the work files from all the hosts.
- --version
- Displays the version of this utility.
- -h | --help
- Displays the online help.
Examples
Example 1: Start the utility specifying the list of hosts from which to collect the information
Create the file /home/gpadmin/hostmap.txt that contains the following:
mdw:/home/gpadmin/gpmemwatcher_dir/working sdw1:/home/gpadmin/gpmemwatcher_dir/working sdw2:/home/gpadmin/gpmemwatcher_dir/working sdw3:/home/gpadmin/gpmemwatcher_dir/working sdw4:/home/gpadmin/gpmemwatcher_dir/working
Make sure that the path /home/gpadmin/gpmemwatcher_dir/working exists on all hosts.
Start the utility:
$ gpmemwatcher -f /home/gpadmin/hostmap.txt
Example 2: Stop utility and dump the resulting into a .gz file
Stop the utility you started in Example 1:
$ gpmemwatcher -f /home/gpadmin/hostmap.txt --stop
The results .gz files will be dumped into the directory where you are running the command:
$ [gpadmin@gpdb-m]$ ls -thrl -rw-rw-r--. 1 gpadmin gpadmin 2.8K Nov 19 15:17 mdw.ps.out.gz -rw-rw-r--. 1 gpadmin gpadmin 2.8K Nov 19 15:17 sdw1.ps.out.gz -rw-rw-r--. 1 gpadmin gpadmin 2.8K Nov 19 15:17 sdw2.ps.out.gz -rw-rw-r--. 1 gpadmin gpadmin 2.8K Nov 19 15:17 sdw3.ps.out.gz -rw-rw-r--. 1 gpadmin gpadmin 2.8K Nov 19 15:17 sdw4.ps.out.gz