+-----------------+------------+-----------------+-----------------+-------------+----------------+
| TABLESPACE_NAME | FILE_NAME | TOTAL_MB | USED_MB | FREE_MB | EXTRA |
+-----------------+------------+-----------------+-----------------+-------------+----------------+
| ts_1 | data_1.dat | 102400.00000000 | 102400.00000000 | 0.00000000 | CLUSTER_NODE=3 |
| ts_1 | data_1.dat | 102400.00000000 | 102400.00000000 | 0.00000000 | CLUSTER_NODE=2 |
| ts_1 | data_1.dat | 102400.00000000 | 102376.00000000 | 24.00000000 | CLUSTER_NODE=4 |
| ts_1 | data_1.dat | 102400.00000000 | 102376.00000000 | 24.00000000 | CLUSTER_NODE=5 |
+-----------------+------------+-----------------+-----------------+-------------+----------------+
现在表空间满了,请问大侠有什么办法增加data_2.dat的大小,使得data_1.dat数据文件里的表能继续insert。
最好能有具体命令。
| TABLESPACE_NAME | FILE_NAME | TOTAL_MB | USED_MB | FREE_MB | EXTRA |
+-----------------+------------+-----------------+-----------------+-------------+----------------+
| ts_1 | data_1.dat | 102400.00000000 | 102400.00000000 | 0.00000000 | CLUSTER_NODE=3 |
| ts_1 | data_1.dat | 102400.00000000 | 102400.00000000 | 0.00000000 | CLUSTER_NODE=2 |
| ts_1 | data_1.dat | 102400.00000000 | 102376.00000000 | 24.00000000 | CLUSTER_NODE=4 |
| ts_1 | data_1.dat | 102400.00000000 | 102376.00000000 | 24.00000000 | CLUSTER_NODE=5 |
+-----------------+------------+-----------------+-----------------+-------------+----------------+
现在表空间满了,请问大侠有什么办法增加data_2.dat的大小,使得data_1.dat数据文件里的表能继续insert。
最好能有具体命令。
这条命令如何修改才会使得新加的数据文件data_12.dat能指定大小并且没有语法错误。
问题已经解决了,向表空间里添加新的数据文件就OK了,
alter tablespace ts_1 add datafile'data_12.dat' initial_size 100G engine ndbcluster;
问题已经解决了,向表空间里添加新的数据文件就OK了,
alter tablespace ts_1 add datafile'data_12.dat' initial_size 100G engine ndbcluster;