The Ultimate Guide to High Availability with MariaDB

Information Schema DISKS Table

You are viewing an old version of this article. View the current version here.

Contents

  1. Installation
  2. Description
  3. Example
  4. See Also

The DISKS plugin allows the disk space situation to be monitored by adding an Information Schema DISKS table which can then be queried.

It was added in MariaDB 10.3.6, MariaDB 10.2.14 and MariaDB 10.1.32.

Installation

Installing the plugin can be performed with the INSTALL PLUGIN or INSTALL SONAME statement, for example.

INSTALL SONAME 'disks';

Description

The table contains the following columns:

ColumnDescription
DISKName of the disk itself.
PATHMount point of the disk.
TOTALTotal space in KiB.
USEDUsed amount of space in KiB.
AVAILABLEAmount of space in KiB available to non-root users.

Note that as the amount of space available to root 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/sda3 | /                     |  47929956 | 30666304 |  14805864 |
  | /dev/sda1 | /boot/efi             |    191551 |     3461 |    188090 |
  | /dev/sda4 | /home                 | 174679768 | 80335392 |  85448120 |
  | /dev/sdb1 | /mnt/hdd              | 961301832 |    83764 | 912363644 |
  | /dev/sdb1 | /home/wikman/Music    | 961301832 |    83764 | 912363644 |
  | /dev/sdb1 | /home/wikman/Videos   | 961301832 |    83764 | 912363644 |
  | /dev/sdb1 | /home/wikman/hdd      | 961301832 |    83764 | 912363644 |
  | /dev/sdb1 | /home/wikman/Pictures | 961301832 |    83764 | 912363644 |
  | /dev/sda3 | /var/lib/docker/aufs  |  47929956 | 30666304 |  14805864 |
  +-----------+-----------------------+-----------+----------+-----------+

See Also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.