Xpand device size 조절

- xpand는 device1라는 파일로 모든 데이터(table, index, 함수 등) , undo log, temp table, Binlog 등이 저장되며,

 파일 크기는 autoextend 방식 아닌 수동으로 늘려야한다.

- 파일 사이즈는 늘리는 거는 쉽지만, 파일 축소는 쉽게 안됨.

- 파일 늘리는 쿼리는 alter cluster resize devices 용량;

 

$ clx space;
nid |  Hostname | Status |      Undo      |      Perm      |    Temp    |      Used       | DB Total | FS Free
----+-----------+--------+---------------+---------------+------------+---------------+----------+--------
  1 |  xnode-1 |    OK  |    1.0M (0.00%) |  188.9G (87.9%) |  0 (0.00%) |  189.0G (88.0%) |   214.9G |    2.8T
  2 |  xnode-2 |    OK  |  256.0K (0.00%) |  181.4G (84.4%) |  0 (0.00%) |  181.5G (84.5%) |   214.9G |    4.2T
  3 |  xnode-3 |    OK  |  256.0K (0.00%) |  184.7G (85.9%) |  0 (0.00%) |  184.7G (86.0%) |   214.9G |    4.2T
----+-----------+--------+-----------------+-----------------+------------+-----------------+----------+--------
                                  1.5M (0.00%) |  555.1G (86.1%) |  0 (0.00%) |  555.2G (86.1%) |   644.6G |   11.1T
$ mysql -uroot -p -A
Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 
Server version: 5.0.45-Xpand-5.3.20 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]>

MySQL [(none)]> ALTER CLUSTER RESIZE DEVICES 2048g;
Query OK, 0 rows affected (1.09 sec)

MySQL [(none)]> \q
Bye
$ clx space;
nid |  Hostname | Status |       Undo      |       Perm      |    Temp    |       Used      | DB Total | FS Free
----+-----------+--------+-----------------+-----------------+------------+-----------------+----------+--------
  1 |  xnode-1 |    OK  |    1.0M (0.00%) |  188.9G (9.25%) |  0 (0.00%) |  189.0G (9.25%) |     2.0T |    1.0T
  2 |  xnode-2 |    OK  |  256.0K (0.00%) |  181.4G (8.88%) |  0 (0.00%) |  181.5G (8.88%) |     2.0T |    2.4T
  3 |  xnode-3 |    OK  |  256.0K (0.00%) |  184.7G (9.04%) |  0 (0.00%) |  184.7G (9.04%) |     2.0T |    2.4T
----+-----------+--------+-----------------+-----------------+------------+-----------------+----------+--------
                                   1.5M (0.00%) |  555.1G (9.06%) |  0 (0.00%) |  555.2G (9.06%) |     6.0T |    5.8T

 

참조 : 

https://mariadb.com/docs/service-management/operations/storage-management/xpand/manage-database-capacity/#device1-main-storage