md_devices

Software RAID array settings.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: md_devices

  • Linux

Table schema

Name

Type

Description

device_name

TEXT

md device name

status

TEXT

Current state of the array

raid_level

INTEGER

Current raid level of the array

size

BIGINT

size of the array in blocks

chunk_size

BIGINT

chunk size in bytes

raid_disks

INTEGER

Number of configured RAID disks in array

nr_raid_disks

INTEGER

Number of partitions or disk devices to comprise the array

working_disks

INTEGER

Number of working disks in array

active_disks

INTEGER

Number of active disks in array

failed_disks

INTEGER

Number of active disks in array

spare_disks

INTEGER

Number of active disks in array

superblock_state

TEXT

State of the superblock

superblock_version

TEXT

Version of the superblock

superblock_update_time

BIGINT

Unix timestamp of last update

bitmap_on_mem

TEXT

Pages allocated in in-memory bitmap, if enabled

bitmap_chunk_size

TEXT

Bitmap chunk size

bitmap_external_file

TEXT

External referenced bitmap file

recovery_progress

TEXT

Progress of the recovery activity

recovery_finish

TEXT

Estimated duration of recovery activity

recovery_speed

TEXT

Speed of recovery activity

resync_progress

TEXT

Progress of the resync activity

resync_finish

TEXT

Estimated duration of resync activity

resync_speed

TEXT

Speed of resync activity

reshape_progress

TEXT

Progress of the reshape activity

reshape_finish

TEXT

Estimated duration of reshape activity

reshape_speed

TEXT

Speed of reshape activity

check_array_progress

TEXT

Progress of the resync activity

check_array_finish

TEXT

Estimated duration of resync activity

check_array_speed

TEXT

Speed of resync activity

unused_devices

TEXT

Unused devices

other

TEXT

Other information associated with array from /proc/mdstat

Query examples

Select all the results for the given table.

SELECT * FROM md_devices;