# Information Schema DISKS Table

{% hint style="warning" %}
The plugin only works on Linux.
{% endhint %}

## Description

The `DISKS` table is created when the [DISKS](/docs/server/reference/plugins/other-plugins/disks-plugin.md) plugin is enabled, and shows metadata about disks on the system.

{% tabs %}
{% tab title="Current" %}
This plugin requires the [FILE privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md).
{% endtab %}

{% tab title="< 10.4.7 / 10.3.17 / 10.2.26 / 10.1.41" %}
{% hint style="danger" %}
This plugin does **not** check [user privileges](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md). When it is enabled, **any** user can query the `INFORMATION_SCHEMA.DISKS` table and see all the information it provides.
{% endhint %}
{% endtab %}
{% endtabs %}

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

```sql
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](/docs/server/reference/plugins/other-plugins/disks-plugin.md) for details on installing, options
* [Plugin Overview](/docs/server/reference/plugins/plugin-overview.md) for details on managing plugins.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-disks-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.