SHOW FRONTENDS DISKS
Description
This statement is used to view the disk information of important directories on the FE node, such as metadata, logs, audit logs, and temporary directories.
Syntax
SHOW FRONTENDS DISKS;
Return Value
| Column | Note |
|---|---|
| Name | The name of the FE node in bdbje |
| Host | The IP address of the FE node. |
| DirType | The types of directories to be displayed include the following four categories: meta, log, audit-log, temp, and deploy. |
| Dir | The directories for the types of directories to be displayed. |
| FileSystem | The file system in the Linux system where the types of directories to be displayed are located. |
| Capacity | The capacity of the file system. |
| Used | The used size of the file system. |
| Available | The remaining capacity of the file system. |
| UseRate | The usage percentage of the file system capacity. |
| MountOn | The mount directory of the file system. |
Access Control Requirements
The user who executes this SQL must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| ADMIN_PRIV or NODE_PRIV |
Usage Notes
If further filtering of the query results is required, the table-valued function frontends_disks() can be used. SHOW BACKENDS is equivalent to the following statement:
SELECT * FROM FRONTENDS_DISKS();
Examples
SHOW FRONTENDS DISKS;
+-----------------------------------------+-------------+-----------+---------------------------------+------------+----------+------+-----------+---------+------------+
| Name | Host | DirType | Dir | Filesystem | Capacity | Used | Available | UseRate | MountOn |
+-----------------------------------------+-------------+-----------+---------------------------------+------------+----------+------+-----------+---------+------------+
| fe_a1daac68_5ec0_477c_b5e8_f90a33cdc1bb | 10.xx.xx.90 | meta | /home/disk/output/fe/doris-meta | /dev/sdf1 | 7T | 2T | 4T | 36% | /home/disk |
| fe_a1daac68_5ec0_477c_b5e8_f90a33cdc1bb | 10.xx.xx.90 | log | /home/disk/output/fe/log | /dev/sdf1 | 7T | 2T | 4T | 36% | /home/disk |
| fe_a1daac68_5ec0_477c_b5e8_f90a33cdc1bb | 10.xx.xx.90 | audit-log | /home/disk/output/fe/log | /dev/sdf1 | 7T | 2T | 4T | 36% | /home/disk |
| fe_a1daac68_5ec0_477c_b5e8_f90a33cdc1bb | 10.xx.xx.90 | temp | /home/disk/output/fe/temp_dir | /dev/sdf1 | 7T | 2T | 4T | 36% | /home/disk |
| fe_a1daac68_5ec0_477c_b5e8_f90a33cdc1bb | 10.xx.xx.90 | deploy | /home/disk/output/fe | /dev/sdf1 | 7T | 2T | 4T | 36% | /home/disk |
+-----------------------------------------+-------------+-----------+---------------------------------+------------+----------+------+-----------+---------+------------+
