Information Schema DISKS Table

The Information Schema DISKS table, created by the DISKS plugin, displays metadata such as total and available space for disks on the system.

The plugin only works on Linux.

Description

The DISKS table is created when the DISKS plugin is enabled, and shows metadata about disks on the system.

Current

This plugin requires the FILE privilege.

< 10.4.7 / 10.3.17 / 10.2.26 / 10.1.41

The table contains the following columns:

Column	Description
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.

Example

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 |
+-----------+-------+----------+---------+-----------+

See Also

• Disks Plugin for details on installing, options

• Plugin Overview for details on managing plugins.

_{This page is licensed: CC BY-SA / Gnu FDL}