Atop connector

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

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.