监控GreenPlum Segment磁盘空间

最新推荐文章于 2023-07-10 14:37:52 发布

原创最新推荐文章于 2023-07-10 14:37:52 发布 · 2.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#GreenPlum

GreenPlum 专栏收录该内容

9 篇文章

订阅专栏

本文介绍如何使用Greenplum数据库中的gp_toolkit模式来快速查询各节点的空闲磁盘空间。通过运行简单的SQL查询，可以获取到各主机名、磁盘空间大小及设备路径等信息，并展示了一个具体的查询示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

gp_toolkit Administrative Schema: The Greenplum Database includes the gp_toolkit schema, which collects system information through log files and operating system commands. You can run a query against the gp_toolkit to quickly view free disk space. Results are shown in bytes.

[gpadmin@mdw ~]$ psql -d zwcdb -U zhongwc -h 192.168.1.23 -W
Password for user zhongwc: 
psql (8.2.15)
Type "help" for help.

zwcdb=# select dfhostname, dfspace,dfdevice from gp_toolkit.gp_disk_free order by dfhostname;
 dfhostname | dfspace  |  dfdevice  
------------+----------+------------
  sdw1      | 51692604 |  /dev/sdb1
  sdw2      | 51692588 |  /dev/sdb1
(2 rows)

[gpadmin@mdw config]$ gpssh -f seg_hosts df -TH
[sdw1] Filesystem    Type     Size   Used  Avail Use% Mounted on
[sdw1] /dev/mapper/VolGroup00-LogVol00
[sdw1]               ext3      54G   3.7G    47G   8% /
[sdw1] /dev/sda1     ext3     104M    14M    85M  14% /boot
[sdw1] tmpfs        tmpfs     1.1G      0   1.1G   0% /dev/shm
[sdw1] /dev/sdb1      xfs      54G   727M    53G   2% /data
[sdw2] Filesystem    Type     Size   Used  Avail Use% Mounted on
[sdw2] /dev/mapper/VolGroup00-LogVol00
[sdw2]               ext3      54G   3.7G    47G   8% /
[sdw2] /dev/sda1     ext3     104M    14M    85M  14% /boot
[sdw2] tmpfs        tmpfs     1.1G      0   1.1G   0% /dev/shm
[sdw2] /dev/sdb1      xfs      54G   727M    53G   2% /data