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.