<\/span><\/h2>\n\n\n\n\u6700\u65b0\u7248\u672c https:\/\/www.gbase8.cn\/657<\/p>\n\n\n\n
GBase 8a\u96c6\u7fa4\u8fd0\u7ef4\u5e38\u7528\u547d\u4ee4\u7b80\u5316\u7248\n============================================\n\u6700\u65b0\u7248\u672c https:\/\/www.gbase8.cn\/657\n============================================\n1\u3001\u67e5\u770b\u96c6\u7fa4\u662f\u5426\u6b63\u5e38\n1.1 \u67e5\u770b\u96c6\u7fa4\u72b6\u6001\ngcadmin\n1.2 \u67e5\u770b\u96c6\u7fa4\u6570\u636e\u4e0d\u4e00\u81f4\u60c5\u51b5,\u540e\u9762\u53ef\u9009\u7684\u6570\u5b57\uff0c\u662f\u663e\u793aevent\u6570\u91cf\uff0c\u9ed8\u8ba416\u4e2a\ngcadmin showdmlevent [number]\ngcadmin showddlevent [number]\ngcadmin showdmlstorageevent [number]\n\u6307\u5b9a\u8868\u5206\u7247\u548cIP\ngcadmin showXXXevent dbname.tablename nX IP\n\u6bd4\u5982\ngcadmin showdmlevent testdb.t1 n1 192.168.0.11\n1.2 \u91cd\u542f\u96c6\u7fa4\u670d\u52a1\nV8 \u5728\u64cd\u4f5c\u7cfb\u7edfroot\u4e0b: service gcware start\/stop\/restart\nV9 \u5728dba\u7528\u6237\u4e0b\uff0c\u4e00\u822c\u662fgbase: gcluster_services all start\/stop\/restart\n2\u3001\u96c6\u7fa4\u547d\u4ee4\u884c\uff0c\u7528\u4e8e\u6267\u884cSQL\u547d\u4ee4\nsu - gbase\n\u4ea4\u4e92\u6a21\u5f0f gccli -uUsername -pPassword -hIP\n\u7b80\u5355\u6267\u884c gccli -uUsername -pPassword -hIP -e\"show processlist\"\n\u6279\u91cf\u6587\u4ef6 gccli -uUsername -pPassword -hIP < allSQL.txt\n3\u3001\u67e5\u770b\u96c6\u7fa4\u8fd0\u884c\u7684SQL\n3.1 \u6307\u5b9a\u8282\u70b9\n\u7b80\u5355 show processlist\n\u5b8c\u6574 show full processlist\n\u8be6\u7ec6 show detail processlist\n3.2 \u6240\u6709\u8c03\u5ea6\u8282\u70b9\nselect COORDINATOR_NAME, ID, user, host, command, start_time, time, state, substring(info,0,100) info from information_schema.COORDINATORS_TASK_INFORMATION where command='query' and time >=0 order by time desc limit 10;\n3.3 \u6240\u6709\u6570\u636e\u8282\u70b9\nselect NODE_NAME, ID, user, host, command, start_time, time, state, substring(info,0,100) info from information_schema.GNODES_TASK_INFORMATION where command='query' and info is not null and info not like '%information_schema.processlist%' order by time desc limit 10;\n4\u3001\u5bfc\u51fa\u6570\u636e\nrmt:select * from ac08 where btime between '2020-01-01' and '2020-02-01' into outfile '\/opt\/ac08.txt' fields terminated by ',' ENCLOSED BY '\"' null_value '\\N'\n5\u3001\u52a0\u8f7d\u6570\u636e\nload data infile 'ftp:\/\/gbase:gbase@192.168.0.100\/\/opt\/ac08.txt' into table ac08 NULL_VALUE '\\N' fields terminated by ',' ENCLOSED BY '\"' DATETIME FORMAT \u2018%Y-%m-%d %H:%i:%s\u2019\n\u5e26\u6beb\u79d2\u7684\u65e5\u671f\nload data infile 'ftp:\/\/gbase:gbase@192.168.0.100\/\/opt\/ac08.txt' into table ac08 NULL_VALUE '\\N' fields terminated by ',' ENCLOSED BY '\"' DATETIME FORMAT \u2018%Y-%m-%d %H:%i:%s.%f\u2019\n6\u3001\u67e5\u770b\u5f53\u524d\u52a0\u8f7d\u8fdb\u5ea6\nselect db_name,tb_name,IP,state,start_time,progress,total_size,loaded_size,loaded_records,skipped_records from information_schema.load_status order by db_name,tb_name;\nselect tb_name,IP,state,ELAPSED_TIME,avg_speed,progress,total_size,loaded_size from information_schema.load_status order by avg_speed;\n7\u3001\u67e5\u770b\u5386\u53f2\u52a0\u8f7d\u7ed3\u679c\nselect task_id,db_name,tb_name,user,HOST_IP,start_time,end_time,elapsed_time,total_size,loaded_records,skipped_records from information_schema.load_result where start_time>'2020-07-26' order by start_time;\n8\u3001\u67e5\u770b\u8868\u3001\u5b58\u50a8\u8fc7\u7a0b\u3001\u51fd\u6570\nshow tables;\nshow tables like '%XXX%' ;\nshow function status;\nshow procedure status;\n9\u3001\u67e5\u770b\u8868\u3001\u51fd\u6570\u3001\u5b58\u50a8\u8fc7\u7a0b\u7ed3\u6784\nshow create table mytablename;\nshow create procedure myProc;\nshow create function myFunc;\n10\u3001\u67e5\u770b\u53d8\u91cf\nshow variables like '%XXXX%';\n\u67e5\u770b\u72b6\u6001\nshow status like '%meminfo%';\n12\u3001\u67e5\u770b\u67d0\u4e2a\u8868\u5360\u7528\u7684\u7a7a\u95f4\nselect * from information_schema.cluster_tables a where table_schema='testdb' and table_name='t1';\n\u67e5\u770b\u6bcf\u4e2a\u5206\u7247\u7684\u7a7a\u95f4\nselect * from information_schema.CLUSTER_TABLE_SEGMENTS a where table_schema='testdb' and table_name='t1';\n13\u3001\u5404\u79cd\u65e5\u5fd7\u4f4d\u7f6e\n\u670d\u52a1 \u8fdb\u7a0b\u540d\u5b57 \u9ed8\u8ba4\u65e5\u5fd7\u4f4d\u7f6e\ngcware corosync\n\u670d\u52a1\u542f\u505c\u65e5\u5fd7\uff0c\u53ea\u6709\u542f\u52a8\u548c\u505c\u6b62\u4fe1\u606f\nV8\u7248\u672c \u5b89\u88c5\u76ee\u5f55\/gcluster\/log\/gcluster\/corosync_system.log\nV9\u7248\u672c \u5b89\u88c5\u76ee\u5f55\/gcluster\/log\/gcluster\/gcware_system.log\n\u670d\u52a1\u8be6\u7ec6\u65e5\u5fd7\uff0c\u8be6\u7ec6\u7684\u542f\u52a8\u505c\u6b62\u4fe1\u606f\nV8\u7248\u672c \/var\/log\/corosync.log\nV9\u7248\u672c \u5b89\u88c5\u76ee\u5f55\/gcware\/log\/gcware.log\ngcadmin\u547d\u4ee4\u6267\u884c\u65e5\u5fd7\nV8\u7248\u672c \/var\/log\/gcware\/gcware_XXXX.log\nV9\u7248\u672c \u5b89\u88c5\u76ee\u5f55\/gcware\/liblog\/gcware.log\ngcluster gclusterd\n\u5b89\u88c5\u76ee\u5f55\/gcluster\/log\/gcluster\/system.log \u542f\u505c\u65e5\u5fd7\n\u5b89\u88c5\u76ee\u5f55\/gcluster\/log\/gcluster\/express.log \u5f15\u64ce\u65e5\u5fd7\n\u5b89\u88c5\u76ee\u5f55\/gcluster\/log\/gcluster\/gclusterd.log \u901a\u7528\u65e5\u5fd7\uff0c\u8bb0\u5f55\u53ef\u6267\u884c\u7684SQL\u547d\u4ee4\n\u5b89\u88c5\u76ee\u5f55\/gcluster\/log\/gcluster\/gclusterd-audit.log \u5ba1\u8ba1\u65e5\u5fd7\uff0c\u8bb0\u5f55\u6240\u6709\u547d\u4ee4\u6267\u884c\u7ed3\u679c\ngnode gbased \u5b89\u88c5\u76ee\u5f55\/gnode\/log\/gbase\/system.log\u542f\u505c\u65e5\u5fd7\n\u5b89\u88c5\u76ee\u5f55\/gnode\/log\/gbase\/express.log\u5f15\u64ce\u65e5\u5fd7\nsyncserver gc_sync_server\n\u5b89\u88c5\u76ee\u5f55\/gnode\/log\/gbase\/syncserver.log \u670d\u52a1\u65e5\u5fd7\n\u5b89\u88c5\u76ee\u5f55\/gnode\/log\/gbase\/ syncclient_XXXX.log \u5ba2\u6237\u7aef\u65e5\u5fd7\ngcrecover\n\u5b89\u88c5\u76ee\u5f55\/gclusger\/log\/gcluster\/ gc_recover.log \u8c03\u5ea6\u65e5\u5fd7\n\u5b89\u88c5\u76ee\u5f55\/gclusger\/log\/gcluster\/gcrecover_taskrecord.log \u540c\u6b65\u8bb0\u5f55\n\u5b89\u88c5\u76ee\u5f55\/gclusger\/log\/gcluster\/gcrecover_system.log \u542f\u505c\u65e5\u5fd7\ngcmonit \u5b89\u88c5\u76ee\u5f55\/gclusger\/log\/gcluster\/gcmonit.log \u8fdb\u7a0b\u76d1\u63a7\ngcmmonit \u5b89\u88c5\u76ee\u5f55\/gclusger\/log\/gcluster\/gcmmonit.log \u8fdb\u7a0b\u76d1\u63a7\u7684\u76d1\u63a7<\/pre>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u63d0\u4f9b\u4e86\u591a\u79cd\u8fd0\u7ef4\u76d1\u63a7\u7528\u7684\u547d\u4ee4\uff0c\u7528\u6765\u67e5\u770b\u5f53\u524d\u96c6\u7fa4\u8fd0\u884c\u72b6\u6001\u662f\u5426\u5f02\u5e38\u3002\u4e5f\u63d0\u4f9b\u4e86\u7b80\u5355\u7684\u5bfc\u5165\u548c\u5bfc\u51fa\u65b9\u6848\u3002\u672c\u6587\u6c47\u603b\u4e86\u5728\u73b0\u573a\u8fd0\u7ef4\u4eba\u5458\u6700\u7ecf\u5e38\u4f7f\u7528\u7684\u547d\u4ee4\u6c47\u603b\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[28],"class_list":["post-657","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-28"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/657","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=657"}],"version-history":[{"count":30,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/657\/revisions"}],"predecessor-version":[{"id":12799,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/657\/revisions\/12799"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}