host_file installer.tar =:/ gpcheckperf--检查网络和硬盘性能(/etc/ssh/sshd_config#MaxStartups 10:30:100) - 检查Disk性能: gpcheckperf -f hosts-setup -d /data1 -d /data2 -r d -D -V -S 1GB gpcheckperf -f hosts-setup -d /data1 /data1 -d /data2 -r d -D -V -S 10GB gpcheckperf -f hosts-setup -d /data1 -d /data2 -r d -D -V - 检查网络性能: gpcheckperf -d /tmp -r N -f hosts-net0 gpcheckperf -d /tmp -r M -f hosts-net0 ## 目录 • Greenplum运维常见问题 序，检查时间最长的SQL） ## 检查硬件和OS状态 查看command Centre中系统监控情况 MegaCli检查磁片和Raid卡状态 - 检查OS是否有硬件错误告警 - gpcheckperf检查网络和磁片性能 ## 问题定位方法 ## 现象-数据库不能访问 对于此类问题，相对来说比较容易定位。 gpstate检查系统状态，此时很可能不会有任何输出 - 采用Utility

Monitoring and Maintenance 342 System Monitoring and Maintenance 0 Monitoring 342 gpstate 342 gpcheckperf 343 Monitoring with Operating System Utilities 343 Best Practices 344 Additional Information exchange SSH keys as the gpadmin user 596 Validating Disk I/O and Memory Bandwidth 596 To run gpcheckperf 596 Integrating New Hardware into the System 596 Initializing New Segments 596 Initializing status field in gpstate - s output for primary segments. 178831426 - gpcheckperf : When executing gpcheckperf via gpssh, the gpcheckperf utility could issue a pkill -f command that killed the gpssh process

Monitoring and Maintenance 351 System Monitoring and Maintenance 0 Monitoring 351 gpstate 351 gpcheckperf 352 Monitoring with Operating System Utilities 352 Best Practices 353 Additional Information exchange SSH keys as the gpadmin user 605 Validating Disk I/O and Memory Bandwidth 605 To run gpcheckperf 605 Integrating New Hardware into the System 605 Initializing New Segments 605 Initializing status field in gpstate - s output for primary segments. 178831426 - gpcheckperf : When executing gpcheckperf via gpssh, the gpcheckperf utility could issue a pkill -f command that killed the gpssh process

Configuring Resource Queues 345 **System Monitoring and Maintenance** 346 Monitoring 346 gpstate 346 gpcheckperf 347 Monitoring with Operating System Utilities 347 Best Practices 347 Additional Information exchange SSH keys as the gpadmin user 596 Validating Disk I/O and Memory Bandwidth 596 To run gpcheckperf 596 Integrating New Hardware into the System 596 Initializing New Segments 596 Creating an Input status field in gpstate - s output for primary segments. 178831426 - gpcheckperf : When executing gpcheckperf via gpssh, the gpcheckperf utility could issue a pkill -f command that killed the gpssh process

exchange SSH keys as the gpadmin user 1099 Validating Disk I/O and Memory Bandwidth 1099 To run gpcheckperf 1099 Integrating New Hardware into the System 1100 Initializing New Segments 1100 Creating an Configuring Resource Queues 1223 System Monitoring and Maintenance 1224 Monitoring 1224 gpstate 1224 gpcheckperf 1225 Monitoring with Operating System Utilities 1225 Best Practices 1226 Additional Information See Also 1963 **gpcheckcat** 1963 Synopsis 1963 Description 1963 Options 1964 Notes 1966 **gpcheckperf** 1967 Synopsis 1967 Description 1967 Options 1968 Examples 1970 See Also 1970 **gpconfig**

exchange SSH keys as the gpadmin user 943 Validating Disk I/O and Memory Bandwidth 943 To run gpcheckperf 943 Integrating New Hardware into the System 943 Initializing New Segments 943 Creating an Input Resource Queues 1048 **System Monitoring and Maintenance** 1049 Monitoring 1049 gpstate 1049 gpcheckperf 1049 Monitoring with Operating System Utilities 1050 Best Practices 1050 Additional Information See Also 1673 **gpcheckcat** 1673 Synopsis 1674 Description 1674 Options 1674 Notes 1676 gpcheckperf 1677 Synopsis 1677 Description 1677 Options 1678 Examples 1679 See Also 1680 gpconfig 1680

Validating Disk I/O and Memory Bandwidth 1115 VMware Greenplum 6 Documentation VMware, Inc 48 To run gpcheckperf 1115 Integrating New Hardware into the System 1115 Initializing New Segments 1115 Creating an Input Configuring Resource Queues 1238 System Monitoring and Maintenance 1239 Monitoring 1239 gpstate 1239 gpcheckperf 1239 Monitoring with Operating System Utilities 1240 Best Practices 1240 Additional Information Examples 1967 See Also 1967 gpcheckcat 1967 Synopsis 1967 Description 1968 Options 1969 Notes 1971 gpcheckperf 1971 Synopsis 1971 Description 1971 Options 1972 Examples 1974 See Also 1974 gpconfig 1975 Synopsis

exchange SSH keys as the gpadmin user 1081 Validating Disk I/O and Memory Bandwidth 1081 To run gpcheckperf 1082 Integrating New Hardware into the System 1082 Initializing New Segments 1082 Creating an Input Configuring Resource Queues 1198 System Monitoring and Maintenance 1199 Monitoring 1200 gpstate 1200 gpcheckperf 1200 VMware Tanzu Greenplum 6 Documentation VMware, Inc 55 Monitoring with Operating System Utilities Documentation VMware, Inc 112 gpcheckcat 1902 Synopsis 1902 Description 1903 Options 1903 Notes 1905 gpcheckperf 1906 Synopsis 1906 Description 1906 Options 1907 Examples 1909 See Also 1909 gpconfig 1909 Synopsis

exchange SSH keys as the gpadmin user 1076 Validating Disk I/O and Memory Bandwidth 1077 To run gpcheckperf 1077 Integrating New Hardware into the System 1077 Initializing New Segments 1077 Creating an Input Configuring Resource Queues 1194 System Monitoring and Maintenance 1195 Monitoring 1195 gpstate 1195 gpcheckperf 1195 Monitoring with Operating System Utilities 1196 Best Practices 1196 Additional Information Examples 1894 See Also 1895 gpcheckcat 1895 Synopsis 1895 Description 1895 Options 1896 Notes 1898 gpcheckperf 1898 Synopsis 1898 Description 1899 Options 1900 Examples 1901 See Also 1902 gpconfig 1902 Synopsis

exchange SSH keys as the gpadmin user 1131 Validating Disk I/O and Memory Bandwidth 1131 To run gpcheckperf 1131 Integrating New Hardware into the System 1132 Initializing New Segments 1132 Creating Resource Queues 1255 System Monitoring and Maintenance 1256 Monitoring 1256 gpstate 1256 gpcheckperf 1257 Monitoring with Operating System Utilities 1257 Best Practices 1258 Additional Information Also 2004 gpcheckcat 2004 Synopsis 2004 Description 2005 Options 2006 Notes 2008 gpcheckperf 2008 Synopsis 2008 Description 2009 Options 2010 Examples 2011 See Also 2012 gpconfig