The plugin only works on Linux.
The DISKS table is created when the DISKS plugin is enabled, and shows metadata about disks on the system.
This plugin requires the FILE privilege.
This plugin does not check user privileges. When it is enabled, any user can query the INFORMATION_SCHEMA.DISKS table and see all the information it provides.
The table contains the following columns:
DISK
Name of the disk itself.
PATH
Mount point of the disk.
TOTAL
Total space in KiB.
USED
Used amount of space in KiB.
AVAILABLE
Amount of space in KiB available to non-root users.
Note that as the amount of space available to root (OS user) may be more that what is available to non-root users, 'available' + 'used' may be less than 'total'.
All paths to which a particular disk has been mounted are reported. The rationale is that someone might want to take different action e.g. depending on which disk is relevant for a particular path. This leads to the same disk being reported multiple times.
SELECT * FROM information_schema.DISKS;
+-----------+-------+----------+---------+-----------+
| Disk | Path | Total | Used | Available |
+-----------+-------+----------+---------+-----------+
| /dev/vda1 | / | 26203116 | 2178424 | 24024692 |
| /dev/vda1 | /boot | 26203116 | 2178424 | 24024692 |
| /dev/vda1 | /etc | 26203116 | 2178424 | 24024692 |
+-----------+-------+----------+---------+-----------+Disks Plugin for details on installing, options
Plugin Overview for details on managing plugins.
This page is licensed: CC BY-SA / Gnu FDL