ALTER CLUSTER RESIZE DEVICES
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Statements for MariaDB Xpand
Topics on this page:
Overview
Resizes the device1 files on all nodes in the cluster.
DETAILS
ALTER CLUSTER RESIZE DEVICES size
Use ALTER CLUSTER RESIZE DEVICES to expand the device1` file on all online nodes. size is the total calculated bytes or a rounded whole integer suffixed by k/m/g for kilobytes, megabytes, or gigabytes.
sql> ALTER CLUSTER RESIZE DEVICES 50g;
All device1 files should be the same size cluster-wide and are all modified by the resize command in parallel. This command does not affect the device1-temp file that is used for sorting and grouping large query results.
For additional information about how to manage the database capacity, see "Manage Storage and Database Capacity for MariaDB Xpand".
ALTER CLUSTER RESIZE DEVICES does not support reducing the size of the device1 file. For additional information about how to reduce the size of the device file, see "Decrease device1 Size for MariaDB Xpand".
Note
Xpand recommends resizing devices during off-peak hours.