ALTER CLUSTER RESIZE DEVICES
device1 files on all nodes in the cluster.
See also: SQL Statements for MariaDB Xpand 6.1
ALTER CLUSTER RESIZE DEVICES size
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;
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".
Xpand recommends resizing devices during off-peak hours.