Atop коннектор#

The Atop connector supports reading disk utilization statistics from the Atop (Advanced System and Process Monitor) Linux server performance analysis tool.

Примечание

Ниже приведена оригинальная документация Trino. Скоро мы ее переведем на русский язык и дополним полезными примерами.

Requirements#

In order to use this connector, the host on which the Trino worker is running needs to have the atop tool installed locally.

Connector configuration#

The connector can read disk utilization statistics on the Trino cluster. Create a catalog properties file that specifies the Atop connector by setting the connector.name to atop.

For example, create the file etc/catalog/example.properties with the following connector properties as appropriate for your setup:

connector.name=atop
atop.executable-path=/usr/bin/atop

Configuration properties#

Property name

Default value

Required

Description

atop.concurrent-readers-per-node

1

Yes

The number of concurrent read operations allowed per node.

atop.executable-path

(none)

Yes

The file path on the local file system for the atop utility.

atop.executable-read-timeout

1ms

Yes

The timeout when reading from the atop process.

atop.max-history-days

30

Yes

The maximum number of days in the past to take into account for statistics.

atop.security

ALLOW_ALL

Yes

The access control for the connector.

atop.time-zone

System default

Yes

The time zone identifier in which the atop data is collected. Generally the timezone of the host. Sample time zone identifiers: Europe/Vienna, +0100, UTC.

Usage#

The Atop connector provides a default schema.

The tables exposed by this connector can be retrieved by running SHOW TABLES:

SHOW TABLES FROM example.default;
  Table
---------
 disks
 reboots
(2 rows)

The disks table offers disk utilization statistics recorded on the Trino node.

Disks columns#

Name

Type

Description

host_ip

VARCHAR

Trino worker IP

start_time

TIMESTAMP(3) WITH TIME ZONE

Interval start time for the statistics

end_time

TIMESTAMP(3) WITH TIME ZONE

Interval end time for the statistics

device_name

VARCHAR

Logical volume/hard disk name

utilization_percent

DOUBLE

The percentage of time the unit was busy handling requests

io_time

INTERVAL DAY TO SECOND

Time spent for I/O

read_requests

BIGINT

Number of reads issued

sectors_read

BIGINT

Number of sectors transferred for reads

write_requests

BIGINT

Number of writes issued

sectors_written

BIGINT

Number of sectors transferred for write

The reboots table offers information about the system reboots performed on the Trino node.

Reboots columns#

Name

Type

Description

host_ip

VARCHAR

Trino worker IP

power_on_time

TIMESTAMP(3) WITH TIME ZONE

The boot/reboot timestamp

SQL support#

The connector provides globally available and read operation statements to access system and process monitor information on your Trino nodes.