<\/span><\/h2>\n\n\n\n\u6211\u4eec\u521b\u5efa1\u4e2aabc\u7528\u6237\uff0c\u6388\u6743abc\u6570\u636e\u5e93\u5168\u90e8\u6743\u9650\u3002<\/p>\n\n\n\n
gbase> create user abc identified by 'abc';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase> grant all on abc.* to abc;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u6d88\u8d39\u8005\u7ec4<\/span><\/h2>\n\n\n\n\u6211\u4eec\u7684\u6d4b\u8bd5\u7528\u6237\uff0c\u5c5e\u4e8e\u8fd9\u4e2a\u6d4b\u8bd5\u7684\u6d88\u8d39\u8005\u7ec4\uff0c\u6211\u4eec\u8bbe\u7f6e\u6700\u591a10\u4e2a\u5e76\u53d1SQL\u6267\u884c\u3002<\/p>\n\n\n\n
gbase> create consumer group cg_max10 comment 'max 10 parrel sql';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.13)\n<\/code><\/pre>\n\n\n\n<\/span>\u5c06\u7528\u6237\u52a0\u5165\u6d88\u8d39\u8005\u7ec4<\/span><\/h2>\n\n\n\ngbase> alter consumer group cg_max10 add user abc;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u9759\u6001\u8d44\u6e90\u6c60<\/span><\/h2>\n\n\n\n\u5173\u6ce8\u91cc\u9762\u7684max_activetask=10\uff0c\u6700\u5927\u6d3b\u8dc3\u4efb\u52a1\u6570\u662f10\u3002<\/p>\n\n\n\n
gbase> create resource pool static_max10(cpu_percent=100,max_memory=4096,max_disk_readio=100,max_disk_writeio=100,max_temp_diskspace=1024,max_disk_space=102400,max_activetask=10)type static;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u52a8\u6001\u8d44\u6e90\u6c60<\/span><\/h2>\n\n\n\n\u6ce8\u610f\u6211\u4eec\u5728\u52a8\u6001\u6c60\u91cc\uff0c\u521b\u5efa\u7684\u6700\u5927\u4efb\u52a1\u6570\u662f2\uff0c\u4ee5\u4fbf\u6211\u4eec\u6d4b\u8bd5\u3002\u56e0\u4e3a\u4e00\u4e2a\u9759\u6001\u6c60\u53ef\u4ee5\u6709\u591a\u4e2a\u52a8\u6001\u6c60\u3002<\/p>\n\n\n\n
gbase> create resource pool dy_max10(priority=1, cpu_percent=100, max_memory=1000, max_temp_diskspace=200, max_disk_space=2000, max_disk_writeio=100, max_disk_readio=100, max_activetask=2)type dynamic base on static_max10;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u8d44\u6e90\u4efb\u52a1\u8ba1\u5212<\/span><\/h2>\n\n\n\ngbase> create resource plan rp_max10;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u8d44\u6e90\u6307\u4ee4(\u88c5\u914d)<\/span><\/h2>\n\n\n\n\u8fd9\u4e00\u6b65\u5c31\u662f\u5c06\u8d44\u6e90\u8ba1\u5212\uff0c\u6d88\u8d39\u8005\u7ec4\uff0c\u8d44\u6e90\u6c60\u88c5\u914d\u5230\u4e00\u8d77\u3002<\/p>\n\n\n\n
gbase> create resource directive rd_max10(plan_name='rp_max10',group_name='cg_max10',pool_name='dy_max10');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n\u521b\u5efa\u4e00\u4e2a\u9ed8\u8ba4\u7684<\/p>\n\n\n\n
gbase> create resource directive rd_default(plan_name='rp_max10',group_name='default_consumer_group',pool_name='dy_max10');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n<\/span>\u6fc0\u6d3b\u8d44\u6e90\u8ba1\u5212<\/span><\/h2>\n\n\n\ngbase> set global active_resource_plan='rp_max10';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.03)<\/code><\/pre>\n\n\n\n<\/span>\u53d1\u8d773\u4e2a\u5e76\u53d1SQL<\/span><\/h2>\n\n\n\n\u901a\u8fc7abc\u7528\u6237\uff0c\u53d1\u8d773\u4e2asql\uff0c\u7136\u540e\u67e5\u770b\u8fd0\u884c\u60c5\u51b5\u5982\u4e0b\u3002<\/p>\n\n\n\n
gbase> show processlist;\n+----+-----------------+------------------+------+---------+-------+-----------------------------+------------------------------------+\n| Id | User | Host | db | Command | Time | State | Info |\n+----+-----------------+------------------+------+---------+-------+-----------------------------+------------------------------------+\n| 1 | event_scheduler | localhost | NULL | Daemon | 16420 | Waiting for next activation | NULL |\n| 4 | root | localhost | abc | Query | 0 | NULL | show processlist |\n| 5 | root | 10.0.2.201:39333 | abc | Sleep | 236 | | NULL |\n| 42 | abc | localhost | abc | Query | 17 | Sending task to gnodes | select count(*),sleep(100) from t1 |\n| 43 | abc | localhost | abc | Query | 13 | Sending task to gnodes | select count(*),sleep(100) from t1 |\n| 44 | abc | localhost | abc | Query | 7 | waiting in res pool | select count(*),sleep(100) from t1 |\n+----+-----------------+------------------+------+---------+-------+-----------------------------+------------------------------------+\n6 rows in set (Elapsed: 00:00:00.00)\n\ngbase> show processlist;\n+----+-----------------+------------------+------+---------+-------+-----------------------------+------------------------------------+\n| Id | User | Host | db | Command | Time | State | Info |\n+----+-----------------+------------------+------+---------+-------+-----------------------------+------------------------------------+\n| 1 | event_scheduler | localhost | NULL | Daemon | 16421 | Waiting for next activation | NULL |\n| 4 | root | localhost | abc | Query | 0 | NULL | show processlist |\n| 5 | root | 10.0.2.201:39333 | abc | Sleep | 237 | | NULL |\n| 42 | abc | localhost | abc | Query | 18 | Sending task to gnodes | select count(*),sleep(100) from t1 |\n| 43 | abc | localhost | abc | Query | 14 | Sending task to gnodes | select count(*),sleep(100) from t1 |\n| 44 | abc | localhost | abc | Query | 8 | waiting in res pool | select count(*),sleep(100) from t1 |\n+----+-----------------+------------------+------+---------+-------+-----------------------------+------------------------------------+\n6 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n\u53ef\u4ee5\u770b\u5230\uff0c\u67092\u4e2aSQL\u662f\u6267\u884c\u4e2d\uff0c\u7b2c3\u4e2a\u662fwaiting in res pool\u7b49\u5f85\u72b6\u6001\u3002<\/p>\n\n\n\n
<\/span>\u6267\u884c\u6700\u7ec8\u7ed3\u679c<\/span><\/h2>\n\n\n\n\u56e0\u4e3a3\u4e2aSQL\u4e0d\u662f\u540c\u65f6\u542f\u52a8\u7684\uff0c\u6240\u4ee5\u7b2c3\u4e2a\u7684waiting\u65f6\u95f4\u53d6\u51b3\u4e8e1\u548c3\u5f00\u59cb\u6267\u884c\u65f6\u95f4\u5dee\u3002\u53ea\u6709\u8fde\u63a51\u6267\u884c\u5b8c\u6bd5\u4e86\uff0c\u624d\u5f00\u59cb\u6267\u884c3.<\/p>\n\n\n\n
\u8fde\u63a51\uff0c100\u79d2\u540e\u5b8c\u6210<\/p>\n\n\n\n
gbase> select count(*),sleep(100) from t1;\n+----------+------------+\n| count(*) | sleep(100) |\n+----------+------------+\n| 0 | 0 |\n+----------+------------+\n1 row in set (Elapsed: 00:01:41.06)\n<\/code><\/pre>\n\n\n\n\u8fde\u63a52\uff0c100\u79d2\u540e\u5b8c\u6210<\/p>\n\n\n\n
gbase> select count(*),sleep(100) from t1;\n+----------+------------+\n| count(*) | sleep(100) |\n+----------+------------+\n| 0 | 0 |\n+----------+------------+\n1 row in set (Elapsed: 00:01:40.26)\n<\/code><\/pre>\n\n\n\n\u8fde\u63a53\uff0c192\u79d2\u540e\u5b8c\u6210\u3002<\/p>\n\n\n\n
gbase> select count(*),sleep(100) from t1;\n+----------+------------+\n| count(*) | sleep(100) |\n+----------+------------+\n| 0 | 0 |\n+----------+------------+\n1 row in set (Elapsed: 00:03:12.06)\n<\/code><\/pre>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u672c\u6587\u4ecb\u7ecdGBase 8a\u7684\u8d44\u6e90\u7ba1\u7406\u7684\u9650\u5236\u96c6\u7fa4\u7684SQL\u5e76\u53d1\u6570\u91cf\u7684\u529f\u80fd<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[48],"class_list":["post-3292","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-48"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3292","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=3292"}],"version-history":[{"count":17,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3292\/revisions"}],"predecessor-version":[{"id":7754,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3292\/revisions\/7754"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=3292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=3292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=3292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}