<\/span><\/h2>\n\n\n\n4\u4e2a\u8ba1\u7b97\u8282\u70b9\u7684\u96c6\u7fa4\u3002
\u96c6\u7fa4\u7248\u672c\uff1a9.5.3.18.123926
\u64cd\u4f5c\u7cfb\u7edf\uff1aredhat 7.3 \u865a\u62df\u673a<\/p>\n\n\n\n
[gbase@gbase_rh7_003 ~]$ gcadmin\nCLUSTER STATE: ACTIVE\nVIRTUAL CLUSTER MODE: NORMAL\n\n====================================\n| GBASE GCWARE CLUSTER INFORMATION |\n====================================\n| NodeName | IpAddress | gcware |\n------------------------------------\n| gcware1 | 10.0.2.103 | OPEN |\n------------------------------------\n====================================================\n| GBASE COORDINATOR CLUSTER INFORMATION |\n====================================================\n| NodeName | IpAddress | gcluster | DataState |\n----------------------------------------------------\n| coordinator1 | 10.0.2.103 | OPEN | 0 |\n----------------------------------------------------\n=========================================================================================================\n| GBASE DATA CLUSTER INFORMATION |\n=========================================================================================================\n| NodeName | IpAddress | DistributionId | gnode | syncserver | DataState |\n---------------------------------------------------------------------------------------------------------\n| node1 | 10.0.2.103 | 2 | OPEN | OPEN | 0 |\n---------------------------------------------------------------------------------------------------------\n| node2 | 10.0.2.104 | 2 | OPEN | OPEN | 0 |\n---------------------------------------------------------------------------------------------------------\n| node3 | 10.0.2.105 | 2 | OPEN | OPEN | 0 |\n---------------------------------------------------------------------------------------------------------\n| node4 | 10.0.2.106 | 2 | OPEN | OPEN | 0 |\n---------------------------------------------------------------------------------------------------------\n\n[gbase@gbase_rh7_003 ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u7528\u6237\u914d\u989d\u9650\u5236<\/span><\/h2>\n\n\n\n\u6ce8\u610f\uff1a\u914d\u989d\u53ea\u5bf9\u8be5\u7528\u6237\u3010\u521b\u5efa\u3011\u7684\u8868\u6709\u6548<\/span>\u3002<\/p>\n\n\n\n<\/span>\u8bbe\u7f6e\u914d\u989d<\/span><\/h2>\n\n\n\n\u901a\u8fc7create user\u65f6\uff0c\u6216\u8005grant\u65f6\uff0c\u7ed9\u7528\u6237\u8bbe\u7f6e\u914d\u989d\u3002<\/p>\n\n\n\n
gbase> create user testq identified by 'testq' limit_storage_size=10K;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.03)\n\ngbase> grant all on testdb.* to testq;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539\u914d\u989d<\/span><\/h3>\n\n\n\n\u901a\u8fc7grant \u65b9\u6cd5\u53ef\u4ee5\u4fee\u6539\u914d\u989d\u3002<\/p>\n\n\n\n
gbase> grant all on testdb.* to testq limit_storage_size=10K;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u770b\u5f53\u524d\u914d\u989d\u4f7f\u7528\u60c5\u51b5<\/span><\/h3>\n\n\n\n<\/span>\u67e5\u770b\u5143\u6570\u636e\u8868<\/span><\/h4>\n\n\n\n\u914d\u989d\u4fe1\u606f\u662f\u5b9a\u65f6\u7edf\u8ba1\u5230\u4e00\u4e2a\u5143\u6570\u636e\u8868\u91cc\u3002<\/p>\n\n\n\n
select * from information_schema.gnodes_user_diskspace_usage where user='XXXXXX'<\/code><\/pre>\n\n\n\n\u5176\u4e2d<\/p>\n\n\n\n
- NODE_NAME \u8282\u70b9\u540d\u5b57<\/li>
- User \u7528\u6237<\/li>
- user_limit_storage_size \u9650\u5236\u6570\u989d<\/li>
- user_storage_size \u5f53\u524d\u4f7f\u7528\u6570\u91cf(\u5b57\u8282)<\/li><\/ul>\n\n\n\n
\u6ce8\u610f\uff1a\u4f7f\u7528\u91cf\uff0c\u662f\u5177\u4f53\u6587\u4ef6\u7684\u5927\u5c0f\uff0c\u4e0d\u5305\u62ec\u76ee\u5f55\u7684\uff0c\u6240\u4ee5\u5bf9\u76ee\u5f55du\u7684\u7ed3\u679c\uff0c\u4e0e\u76ee\u5f55\u5185\u6240\u6709\u6587\u4ef6\u7684\u5927\u5c0f\u7d2f\u52a0\u7ed3\u679c\uff0c\u662f\u6709\u5dee\u5f02\u7684\u3002<\/span><\/p>\n\n\n\n<\/span>\u914d\u989d\u5237\u65b0\u5b9a\u65f6\u53c2\u6570<\/span><\/h4>\n\n\n\n\u662f\u7531_gbase_storage_flush_interval\u63a7\u5236\uff0c\u9ed8\u8ba460\uff0c\u5355\u4f4d\u79d2\u3002<\/p>\n\n\n\n
\u4ece\u9879\u76ee\u5b9e\u9645\u60c5\u51b5\u8003\u8651\uff0c\u5f3a\u70c8\u5efa\u8bae\u5237\u65b0\u65f6\u95f4\u63d0\u9ad8\uff0c\u6bd4\u598215\u5206\u949f\uff0c1\u5c0f\u65f6\u3002\u592a\u9891\u7e41\u7684\u5237\u65b0\uff0c\u7279\u522b\u662f\u8be5\u7528\u6237\u8868\u975e\u5e38\u591a\u65f6\uff0c\u4f1a\u989d\u5916\u6d6a\u8d39\u5f88\u591a\u6b21\u78c1\u76d8\u7684IO\u3002<\/span><\/p>\n\n\n\n\u6211\u4eec\u4e3a\u4e86\u6d4b\u8bd5\uff0c\u5c06\u53c2\u6570\u6539\u621010\u79d2\u3002<\/p>\n\n\n\n
gbase> show variables like '%_gbase_storage_flush_interval%';\n+-------------------------------+-------+\n| Variable_name | Value |\n+-------------------------------+-------+\n| _gbase_storage_flush_interval | 60 |\n+-------------------------------+-------+\n1 row in set (Elapsed: 00:00:00.01)\ngbase> set global _gbase_storage_flush_interval=10;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u5f3a\u5236\u5237\u65b0\u914d\u989d\u4fe1\u606f<\/span><\/h4>\n\n\n\ngbase> refresh user storage usage;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5\u6837\u4f8b<\/span><\/h2>\n\n\n\n\u5982\u4e0b\u4ee5testq\u7528\u6237\uff0c\u914d\u989d10K\u4e3a\u6837\u4f8b\uff0c\u6d4b\u8bd5\u7684\u7ed3\u679c\u3002<\/p>\n\n\n\n
<\/span>\u6d4b\u8bd5\u8868<\/span><\/h3>\n\n\n\n\u5c31\u4e00\u4e2aint\u7684\u5355\u5217\u3002\u7528\u6d4b\u8bd5\u914d\u989d\u7684\u7528\u6237testq\u767b\u5f55\uff0c\u521b\u5efa\u65b0\u8868\u3002<\/p>\n\n\n\n
[gbase@gbase_rh7_003 ~]$ gccli -utestq -ptestq\n\nGBase client 9.5.3.18.123926. Copyright (c) 2004-2020, GBase. All Rights Reserved.\n\ngbase> use testdb;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase> create table testq_1(id int);\nQuery OK, 0 rows affected (Elapsed: 00:00:00.13)\n<\/code><\/pre>\n\n\n\n<\/span>\u6dfb\u52a0\u6570\u636e<\/span><\/h3>\n\n\n\ngbase> insert into testq_1 values(1),(2),(3),(4);\nQuery OK, 4 rows affected (Elapsed: 00:00:00.09)\nRecords: 4 Duplicates: 0 Warnings: 0\n\ngbase> select * from information_schema.gnodes_user_diskspace_usage where user='testq'\\G\n*************************** 1. row ***************************\n NODE_NAME: node1\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 38\n*************************** 2. row ***************************\n NODE_NAME: node2\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 38\n*************************** 3. row ***************************\n NODE_NAME: node3\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 0\n*************************** 4. row ***************************\n NODE_NAME: node4\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 0\n4 rows in set (Elapsed: 00:00:00.00)\n\n\n\ngbase> insert into testq_1 select id+power(2,2) from testq_1;\nQuery OK, 4 rows affected (Elapsed: 00:00:00.09)\nRecords: 4 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,3) from testq_1;\nQuery OK, 8 rows affected (Elapsed: 00:00:00.08)\nRecords: 8 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,4) from testq_1;\nQuery OK, 16 rows affected (Elapsed: 00:00:00.08)\nRecords: 16 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,5) from testq_1;\nQuery OK, 32 rows affected (Elapsed: 00:00:00.08)\nRecords: 32 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,6) from testq_1;\nQuery OK, 64 rows affected (Elapsed: 00:00:00.08)\nRecords: 64 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,7) from testq_1;\nQuery OK, 128 rows affected (Elapsed: 00:00:00.08)\nRecords: 128 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,8) from testq_1;\nQuery OK, 256 rows affected (Elapsed: 00:00:00.08)\nRecords: 256 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,9) from testq_1;\nQuery OK, 512 rows affected (Elapsed: 00:00:00.08)\nRecords: 512 Duplicates: 0 Warnings: 0\n\ngbase> insert into testq_1 select id+power(2,10) from testq_1;\nQuery OK, 1024 rows affected (Elapsed: 00:00:00.08)\nRecords: 1024 Duplicates: 0 Warnings: 0<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u770b\u5df2\u7ecf\u4f7f\u7528\u7684\u914d\u989d<\/span><\/h3>\n\n\n\n\u4ece\u5404\u4e2a\u8282\u70b9\u770b\uff0c\u5176\u603b\u548c\u5df2\u7ecf\u8d85\u8fc7\u4e8610K\u3002\u540e\u9762\u7ee7\u7eed\u589e\u52a0\u6570\u636e\u3002<\/p>\n\n\n\n
gbase> select * from information_schema.gnodes_user_diskspace_usage where user='testq'\\G\n*************************** 1. row ***************************\n NODE_NAME: node1\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 6212\n*************************** 2. row ***************************\n NODE_NAME: node2\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 6212\n*************************** 3. row ***************************\n NODE_NAME: node3\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 0\n*************************** 4. row ***************************\n NODE_NAME: node4\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 0\n4 rows in set (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5\u914d\u989d\u9650\u5236\u70b9<\/span><\/h3>\n\n\n\n\u5982\u4e0b\u6d4b\u8bd5\u53ef\u4ee5\u770b\u5230\uff0c\u53ef\u4ee5\u518d\u6b21\u589e\u52a0\u6570\u636e\uff0c\u4e5f\u5c31\u662f\u914d\u989d\u5e76\u4e0d\u662f\u6240\u6709\u8282\u70b9\u7684\u603b\u91cf\u3002<\/p>\n\n\n\n
\u518d\u6b21\u589e\u52a0\u540e\uff0c\u5355\u4e2a\u8282\u70b9\u7684\u6570\u91cf\uff0812356\uff09\u5df2\u7ecf\u8d85\u8fc7\u914d\u989d(10K)\u4e86\u3002<\/p>\n\n\n\n
gbase> insert into testq_1 select id+power(2,11) from testq_1;\nQuery OK, 2048 rows affected (Elapsed: 00:00:00.09)\nRecords: 2048 Duplicates: 0 Warnings: 0\n\ngbase> select * from information_schema.gnodes_user_diskspace_usage where user='testq'\\G\n*************************** 1. row ***************************\n NODE_NAME: node1\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 12356\n*************************** 2. row ***************************\n NODE_NAME: node2\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 12356\n*************************** 3. row ***************************\n NODE_NAME: node3\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 0\n*************************** 4. row ***************************\n NODE_NAME: node4\n User: testq \nuser_limit_storage_size: 10K\n user_storage_size: 0\n4 rows in set (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5\u8d85\u8fc7\u914d\u989d<\/span><\/h3>\n\n\n\n\u8d85\u8fc7\u914d\u989d\u540e\uff0c\u518d\u6b21\u589e\u52a0\u6570\u636e\uff0c\u5c06\u76f4\u63a5\u62a5\u9519\uff1aThe disk space of User 'testq' has exceeded the limit value.(Usage: 12356, Limit: 10240)<\/p>\n\n\n\n
gbase> insert into testq_1 select id+power(2,12) from testq_1;\nERROR 1708 (HY000): [10.0.2.103:5050](GBA-02AD-0005)Failed to query in gnode:\nDETAIL: (GBA-01EX-700) Gbase general error: (gns_host: 10.0.2.103) The disk space of User 'testq' has exceeded the limit value.(Usage: 12356, Limit: 10240)\nSQL: SELECT \/*10.0.2.103_142_22_2020-12-10_15:03:56*\/ \/*+ TID('196838') *\/ (`vcname000001.testdb.testq_1`.`id` + pow(2, 12)) AS `id+power(2,12)` FROM `testdb`.`testq_1_n1` `vcname000001.testdb.testq_1` target into server (HOST '10.0.2.103,10.0.2.104', PORT 5050, USER 'testq', PASSWORD '', DATABAS\ngbase>\n<\/code><\/pre>\n\n\n\n<\/span>Others<\/span><\/h2>\n\n\n\n<\/span>\u65e0\u914d\u989d\u7528\u6237\u5f71\u54cd<\/span><\/h3>\n\n\n\n\u6d4b\u8bd5\u53d1\u73b0\uff0c\u65e0\u914d\u989d\u7528\u6237\uff0c\u5e76\u4e0d\u4f1a\u5b9a\u65f6\u7edf\u8ba1\u5360\u7528\u91cf\u3002<\/p>\n\n\n\n
gbase> select * from information_schema.gnodes_user_diskspace_usage where user='gbase'\\G\n*************************** 1. row ***************************\n NODE_NAME: node1\n User: gbase \nuser_limit_storage_size:\n user_storage_size: 0\n*************************** 2. row ***************************\n NODE_NAME: node2\n User: gbase \nuser_limit_storage_size:\n user_storage_size: 0\n*************************** 3. row ***************************\n NODE_NAME: node3\n User: gbase \nuser_limit_storage_size:\n user_storage_size: 0\n*************************** 4. row ***************************\n NODE_NAME: node4\n User: gbase \nuser_limit_storage_size:\n user_storage_size: 0\n4 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u652f\u6301\u7528\u6237\u7ea7\u78c1\u76d8\u914d\u989d\u9650\u5236\uff0c\u901a\u8fc7\u8bbe\u7f6e\u7528\u6237\u7684\u78c1\u76d8\u4f7f\u7528\u4e0a\u9650\uff0c\u9650\u5236\u6240\u8bbe\u7f6e\u7528\u6237\u521b\u5efa\u8868\u7684sys_tablespace \u548c metadata \u7a7a\u95f4\u603b\u548c\u3002\u8d85\u8fc7\u914d\u989d\u540e\u4f1a\u62a5\u9519The disk space of User 'testq' has exceeded the limit value.<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[],"class_list":["post-2386","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=2386"}],"version-history":[{"count":27,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2386\/revisions"}],"predecessor-version":[{"id":8489,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2386\/revisions\/8489"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}