<\/span><\/h3>\n\n\n\n\u901a\u8fc7\u7cfb\u7edf\u5143\u6570\u636e\u8868 information_schema.tablespaces \u83b7\u5f97<\/p>\n\n\n\n
gbase> select * from tablespaces where db_name='ab';\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| NODE_NAME | DB_NAME | TABLESPACE_ID | TABLESPACE_NAME | TABLESPACE_PATH | IS_DEFAULT | MAX_SIZE | USED_SIZE | FREE_SIZE | SEG_SIZE |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| node1 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node2 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n2 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n- NODE_NAME \u8282\u70b9\u540d\u5b57\uff0c \u53ef\u4ee5\u770bgcadmin showdistribution\u7684\u8f93\u51fa<\/li>
- DB_NAME \u5e93\u540d<\/li>
- TABLESPACE_ID \u8868\u7a7a\u95f4ID<\/li>
- TABLESPACE_NAME \u8868\u7a7a\u95f4\u540d\u5b57\uff0c\u9ed8\u8ba4\u8868\u7a7a\u95f4\u540d\u5b57\u56fa\u5b9a\u53ebsys_tablespace\u3002\u5176\u5b83\u8868\u7a7a\u95f4\u662f\u7528\u6237\u521b\u5efa\u65f6\u6307\u5b9a\u7684\u540d\u5b57<\/li>
- TABLESPACE_PATH \u8868\u7a7a\u95f4\u8def\u5f84 \u5982\u4e0a\u4f8b\u5b50\u662f\u7528\u7684\u7edd\u5bf9\u8def\u5f84<\/li>
- IS_DEFAULT \u662f\u5426\u4e3a\u9ed8\u8ba4\u8868\u7a7a\u95f4\uff0c yes=\u662f<\/li>
- MAX_SIZE \u8868\u7a7a\u95f4\u6700\u5927\u914d\u989d(\u5b57\u8282)<\/li>
- FREE_SIZE \u53ef\u7528\u7a7a\u95f4(\u5b57\u8282)<\/li>
- SEG_SIZE \u6570\u636e\u6587\u4ef6\u7684\u5207\u5206\u5927\u5c0f(\u5b57\u8282)\uff0c\u5982\u4e0d\u6307\u5b9a\u5219\u4e3adefault\uff0c \u548c\u6570\u636e\u5e93\u53c2\u6570\u4e00\u81f4<\/li><\/ul>\n\n\n\n
\u8868\u7a7a\u95f4\u7684\u914d\u7f6e\uff0c\u4fdd\u5b58\u5728\u8c03\u5ea6\u8282\u70b9\u7684\u5bf9\u5e94\u5e93\u7684\u7684tablespace.cnf\u6587\u4ef6\u91cc<\/p>\n\n\n\n
[gbase@gbase_rh7_001 ab]$ cd \/opt\/gbase\/gcluster\/userdata\/gcluster\/vc00001_ab\n[gbase@gbase_rh7_001 vc00001_ab]$ ll\ntotal 4\ndrwx------. 3 gbase gbase 48 Dec 16 13:50 metadata\n-rw-------. 1 gbase gbase 153 Dec 16 13:54 tablespace.cnf\n[gbase@gbase_rh7_001 vc00001_ab]$ cat tablespace.cnf\n[common]\ndefault_id=1\nlast_id=1\n\n[tablespace:0]\nid=1\nname=sys_tablespace\ndir=\/opt\/gbase\/tablespace_100m\nmax_size=104857600\nseg_size=16777216\nused_size=0\n[gbase@gbase_rh7_001 vc00001_ab]$\n<\/code><\/pre>\n\n\n\n\u8b66\u544a<\/span><\/strong><\/p>\n\n\n\n\u4ece\u5f53\u524d\u30102021-12-30\u3011\u5b9e\u73b0\u7684\u65b9\u6848\u770b\uff0c\u8be5tablespace.cnf\u53ea\u6709\u4e00\u4e2a\u6587\u4ef6\uff0c\u5982\u679c\u7528\u6237\u6709\u5927\u91cf\u7684\u591a\u8868\u5e76\u53d1dml\u64cd\u4f5c\uff0c\u6b64\u5904\u4f1a\u989d\u5916\u591a\u51fa\u4e00\u4e2a\u4e32\u884c\u9501\uff0c\u5e76\u53ef\u80fd\u5f71\u54cd\u6027\u80fd\u3002\u5efa\u8bae\u8fd8\u662f\u5bf9\u6709\u78c1\u76d8\u7a7a\u95f4\u5360\u7528\u5927\u7684\u8868\uff0c\u505a\u5355\u72ec\u7684\u8868\u7a7a\u95f4\u7ba1\u7406\uff0c\u5bf9\u666e\u901a\u8868\uff0c\u8fd8\u662f\u4f7f\u7528\u6570\u636e\u5e93\u9ed8\u8ba4\u7684\u8868\u7a7a\u95f4\u3002<\/span><\/p>\n\n\n\n<\/span>\u4fee\u6539<\/span><\/h3>\n\n\n\n\u4e0d\u652f\u6301\u4fee\u6539\u5e93(database)\u7684\u9ed8\u8ba4\u8868\u7a7a\u95f4\u3002\u5982\u786e\u5b9e\u8981\u6539\u52a8\uff0c\u53ef\u4ee5\u901a\u8fc7\u6587\u4ef6\u7cfb\u7edf\u5c42\u9762\u7684link\/mount\u8fdb\u884c\u3002<\/p>\n\n\n\n
<\/span>\u8868(table)\u7684\u8868\u7a7a\u95f4\u4f7f\u7528<\/span><\/h2>\n\n\n\n\u6570\u636e\u5e93\u5185\u7684\u8868\uff0c\u5982\u679c\u4e0d\u6307\u5b9a\u8868\u7a7a\u95f4\uff0c\u5219\u9ed8\u8ba4\u4f7f\u7528\u5e93\u7684\u9ed8\u8ba4\u8868\u7a7a\u95f4\u3002<\/p>\n\n\n\n
<\/span>\u521b\u5efa\u666e\u901a\u8868\u7a7a\u95f4\u8bed\u6cd5<\/span><\/h3>\n\n\n\nCREATE TABLESPACE [IF NOT EXISTS] [[vc_name.]database_name.]<tablespace_name> DATADIR <path> [SEGSIZE <segsize_value>] [MAXSIZE <maxsize_value>]<\/code><\/pre>\n\n\n\n- vc_name VC\u540d\u5b57\u3002 \u53ef\u4ee5\u901a\u8fc7show vcs\u67e5\u770bvcid\u548cvcname, \u53ef\u9009<\/li>
- database_name \u5e93\u540d , \u53ef\u9009<\/li>
- tablespace_name \u8868\u7a7a\u95f4\u540d\u5b57\uff0c\u4e00\u4e2a\u5e93\u5185\u4e0d\u80fd\u91cd\u590d\u3002\u652f\u6301\u6570\u5b57\u82f1\u6587\u548c\u4e0b\u5212\u7ebf\uff0c\u957f\u5ea6\u4e3a 64 \u4e2a\u5b57\u7b26\uff0c\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff0c\u5168\u90e8\u6309\u7167\u5c0f\u5199\u5b57\u7b26\u521b\u5efa\uff0c\u4e14\u4e0d\u5141\u8bb8\u4ee5\u6570\u5b57\u5f00\u5934\u3002<\/li>
- path \u8868\u7a7a\u95f4\u6240\u5bf9\u5e94\u7684\u5b9e\u9645\u7cfb\u7edf\u8def\u5f84\uff0c\u8def\u5f84\u652f\u6301\u76f8\u5bf9\u8def\u5f84\u548c\u7edd\u5bf9\u8def\u5f84\uff0c\u76f8\u5bf9\u8def\u5f84\u662f\u76f8\u5bf9\u4e8e\u914d\u7f6e\u6587\u4ef6\u4e2d\u914d\u7f6e\u7684 datadir \u8def\u5f84<\/li>
- SEGSIZE \u53ef\u9009\uff0c \u6570\u636e\u6587\u4ef6\u7684\u5206\u5272\u5927\u5c0f\uff0c\u8bf7\u53c2\u8003\u524d\u9762\u5e93\u8868\u7a7a\u95f4\u4ecb\u7ecd<\/li>
- MAXSIZE \u53ef\u9009\uff0c\u6700\u5927\u914d\u989d\u9650\u5236\uff0c\u8bf7\u53c2\u8003\u524d\u9762\u5e93\u8868\u7a7a\u95f4\u4ecb\u7ecd<\/li><\/ul>\n\n\n\n
\u6837\u4f8b\uff0c\u5982\u4e0b\u662f\u521b\u5efa2\u4e2a\u5e93\u7684\u8868\u7a7a\u95f4\u3002<\/p>\n\n\n\n
gbase> create tablespace ab.ts_1 datadir '\/opt\/gbase\/tablespace_1' segsize 10m maxsize=50m;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase> create tablespace ab.ts_2 datadir '\/opt\/gbase\/tablespace_2' segsize 16m maxsize=200m;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n\ngbase> select * from information_schema.tablespaces where db_name='ab';\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| NODE_NAME | DB_NAME | TABLESPACE_ID | TABLESPACE_NAME | TABLESPACE_PATH | IS_DEFAULT | MAX_SIZE | USED_SIZE | FREE_SIZE | SEG_SIZE |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| node1 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node1 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 0 | 52428800 | 10485760 |\n| node1 | ab | 3 | ts_2 | \/opt\/gbase\/tablespace_2 | no | 209715200 | 0 | 209715200 | 16777216 |\n| node2 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node2 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 0 | 52428800 | 10485760 |\n| node2 | ab | 3 | ts_2 | \/opt\/gbase\/tablespace_2 | no | 209715200 | 0 | 209715200 | 16777216 |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n6 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539\u8868\u7a7a\u95f4<\/span><\/h3>\n\n\n\n\u53ea\u80fd\u63d0\u9ad8\u8868\u7a7a\u95f4\u7684\u914d\u989d\uff0c\u4e0d\u80fd\u51cf\u5c11\uff0c\u5176\u5b83\u53c2\u6570\u4e0d\u80fd\u4fee\u6539\u3002 \u5982\u5fc5\u987b\u6539\u52a8\uff0c\u8bf7\u5220\u9664\u91cd\u5efa\u8868\u7a7a\u95f4\uff0c\u5f53\u7136\u8981\u6ce8\u610f\u8be5\u8868\u7a7a\u95f4\u5df2\u7ecf\u5b58\u5728\u7684\u8868\u3002<\/p>\n\n\n\n
\u5982\u4e0b\u4f8b\u5b50\u5c06ts_2\u7684\u914d\u989d\u6539\u6210\u4e86400M<\/p>\n\n\n\n
gbase> alter tablespace ab.ts_2 maxsize=200m;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase> alter tablespace ab.ts_2 maxsize=199m;\nERROR 1700 (HY000): (GBA-02DD-0021) gcluster tablespace error: (GBA-01EX-700) Gbase general error: tablespace max size invalidate..\ngbase> alter tablespace ab.ts_2 maxsize=201m;\ngbase> alter tablespace ab.ts_2 maxsize=400m;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n\ngbase> select * from information_schema.tablespaces where db_name='ab';\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| NODE_NAME | DB_NAME | TABLESPACE_ID | TABLESPACE_NAME | TABLESPACE_PATH | IS_DEFAULT | MAX_SIZE | USED_SIZE | FREE_SIZE | SEG_SIZE |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| node1 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node1 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 0 | 52428800 | 10485760 |\n| node1 | ab | 3 | ts_2 | \/opt\/gbase\/tablespace_2 | no | 419430400 | 0 | 419430400 | 16777216 |\n| node2 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node2 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 0 | 52428800 | 10485760 |\n| node2 | ab | 3 | ts_2 | \/opt\/gbase\/tablespace_2 | no | 419430400 | 0 | 419430400 | 16777216 |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n6 rows in set (Elapsed: 00:00:00.01)\n\n<\/code><\/pre>\n\n\n\n<\/span>\u5220\u9664\u8868\u7a7a\u95f4<\/span><\/h3>\n\n\n\nDROP TABLESPACE [[vc_name.]database_name.]<tablespace_name>;\n<\/code><\/pre>\n\n\n\n\u4f8b\u5b50<\/p>\n\n\n\n
gbase> drop tablespace ab.ts_2;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n\ngbase> select * from information_schema.tablespaces where db_name='ab';\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| NODE_NAME | DB_NAME | TABLESPACE_ID | TABLESPACE_NAME | TABLESPACE_PATH | IS_DEFAULT | MAX_SIZE | USED_SIZE | FREE_SIZE | SEG_SIZE |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| node1 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node1 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 0 | 52428800 | 10485760 |\n| node2 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node2 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 0 | 52428800 | 10485760 |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n4 rows in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>\u5efa\u8868\u65f6\u6307\u5b9a\u8868\u7a7a\u95f4<\/span><\/h2>\n\n\n\n\u8868\u6570\u636e\u653e\u5230\u5404\u81ea\u6307\u5b9a\u7684\u8868\u7a7a\u95f4\u5185\uff0c\u5982\u679c\u6ca1\u6307\u5b9a\u5219\u5728\u5e93\u7684\u9ed8\u8ba4\u8868\u7a7a\u95f4\u5185\u3002<\/p>\n\n\n\n
gbase> create table t2(id int) tablespace='ts_1';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.19)\n\ngbase> insert into t2 select * from t1;\nQuery OK, 40000000 rows affected (Elapsed: 00:00:09.31)\nRecords: 40000000 Duplicates: 0 Warnings: 0\n\ngbase> select * from information_schema.tablespaces where db_name='ab';\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| NODE_NAME | DB_NAME | TABLESPACE_ID | TABLESPACE_NAME | TABLESPACE_PATH | IS_DEFAULT | MAX_SIZE | USED_SIZE | FREE_SIZE | SEG_SIZE |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n| node1 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node1 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 80020808 | 0 | 10485760 |\n| node2 | ab | 1 | sys_tablespace | \/opt\/gbase\/tablespace_100m | yes | 104857600 | 80252044 | 24605556 | 16777216 |\n| node2 | ab | 2 | ts_1 | \/opt\/gbase\/tablespace_1 | no | 52428800 | 80020808 | 0 | 10485760 |\n+-----------+---------+---------------+-----------------+----------------------------+------------+-----------+-----------+-----------+----------+\n4 rows in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n\u67e5\u770b\u8868\u7ed3\u6784<\/p>\n\n\n\n
gbase> show create table t2;\n+-------+-------------------+\n| Table | Create Table |\n+-------+-------------------+\n| t2 | CREATE TABLE \"t2\" (\n \"id\" int(11) DEFAULT NULL\n) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='ts_1'<\/span> |\n+-------+-------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> show create table t1;\n+-------+----------------------------+\n| Table | Create Table |\n+-------+----------------------------+\n| t1 | CREATE TABLE \"t1\" (\n \"id\" int(11) DEFAULT NULL\n) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace'<\/span> |\n+-------+-----------------------------+\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n