mysql> create tablespace ts3 add datafile ‘ts3_1.dat‘ use logfile group lg1 initial_size=1G engine=ndb;
Query OK, 0 rows affected (9.41 sec)
mysql> select * from isf;
+-----------+-------------+------------+----------+----------------+
| FILE_NAME | Total | Free | % Free | EXTRA |
+-----------+-------------+------------+----------+----------------+
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=3 |
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=4 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=3 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=4 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=3 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=4 |
+-----------+-------------+------------+----------+----------------+
6 rows in set (0.00 sec)
mysql> create tablespace ts4 add datafile ‘ts4_1.dat‘ use logfile group lg1 initial_size=10G engine=ndb;
Query OK, 0 rows affected (1 min 28.91 sec)
mysql> select * from isf;
+-----------+-------------+------------+----------+----------------+
| FILE_NAME | Total | Free | % Free | EXTRA |
+-----------+-------------+------------+----------+----------------+
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=3 |
| ts1_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=4 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=3 |
| ts2_1.dat | 1048576000 | 1048576000 | 100.0000 | CLUSTER_NODE=4 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=3 |
| ts3_1.dat | 1073741824 | 1073741824 | 100.0000 | CLUSTER_NODE=4 |
| ts4_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=3 |
| ts4_1.dat | 10737418240 | 2147483648 | 20.0000 | CLUSTER_NODE=4 |
+-----------+-------------+------------+----------+----------------+
mysql free tablespace
原文:http://www.blogjava.net/ivanwan/archive/2014/12/31/421998.html