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 | 
|---|---|---|---|
| 
 | 
 | Yes | The number of concurrent read operations allowed per node. | 
| 
 | (none) | Yes | The file path on the local file system for the  | 
| 
 | 
 | Yes | The timeout when reading from the atop process. | 
| 
 | 
 | Yes | The maximum number of days in the past to take into account for statistics. | 
| 
 | 
 | Yes | The access control for the connector. | 
| 
 | System default | Yes | The time zone identifier in which the atop data is collected. Generally the timezone of the host.
Sample time zone identifiers:  | 
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.
| Name | Type | Description | 
|---|---|---|
| 
 | 
 | Trino worker IP | 
| 
 | 
 | Interval start time for the statistics | 
| 
 | 
 | Interval end time for the statistics | 
| 
 | 
 | Logical volume/hard disk name | 
| 
 | 
 | The percentage of time the unit was busy handling requests | 
| 
 | 
 | Time spent for I/O | 
| 
 | 
 | Number of reads issued | 
| 
 | 
 | Number of sectors transferred for reads | 
| 
 | 
 | Number of writes issued | 
| 
 | 
 | Number of sectors transferred for write | 
The reboots table offers information about the system reboots performed on the Trino node.
| Name | Type | Description | 
|---|---|---|
| 
 | 
 | Trino worker IP | 
| 
 | 
 | 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.