You can run the iostat or pidstat command, or use openGauss heath check tools to check the I/O usage and throughput on each node in openGauss and analyze whether performance bottleneck caused by I/O exists.
Checking I/O Usage
Use one of the following methods to check the server I/O:
· Run the iostat command to check the I/O usage. This command focuses on the I/O usage and the amount of data read and written on a single hard disk per second.
rMB/s indicates the number of megabytes of data read per second, wMB/s indicates that of data written per second, and %util indicates the disk usage.
· Run the pidstat command to check the I/O usage. This command focuses on the amount of data read and written on a single process per second.
kB_rd/s indicates the number of kilobytes of data read per second, and kB_wr/s indicates that of data written per second.
Run the gs_checkperf command as user omm to check the I/O usage in openGauss.
The I/O usage, number of reads and writes, and time when data is read and written are displayed.
You can also run the gs_checkperf –detail command to query performance details of each node.
Analyzing Performance Parameters
- Check whether the disk usage exceeds 60%. Disk usage exceeding 60% is called high.
- Perform the following operations to reduce I/O usage if the I/O usage keeps high:
2.1 Reduce the number of concurrent tasks.
2.2 Do VACUUM FULL for related tables.
Top comments (0)