s0000000346_GB_MAT0000007E8554A0xbe87080.express_tmp<\/code><\/pre>\n\n\n\n\u5bf9\u5e94gncli\u91cc\u7684ID\u5217\u3002\u5982\u4e0b\u7b2c\u4e00\u884cID=346\u7684\u662f\u4e00\u4e2aselect join\u7684\u8bed\u53e5\uff0c\u4ea7\u751f\u4e86\u4e2d\u95f4\u7ed3\u679c\u96c6\uff0c\u5199\u5230\u4e86tmpdata\u76ee\u5f55\u4e0b\u3002<\/p>\n\n\n\n
[gbase@gbase_rh7_001 cache_gbase]$ gncli -e\"show processlist\"\n+-----+------+------------------+---------+---------+------+-------+------------------------------------------------------------------------------------------------------+\n| Id | User | Host | db | Command | Time | State | Info |\n+-----+------+------------------+---------+---------+------+-------+------------------------------------------------------------------------------------------------------+\n| 346 | root | 10.0.2.101:41714 | gctmpdb | Query | 107 | init | SELECT \/*10.0.2.101_104_163_2021-01-27_08:47:07*\/ \/*+ TID('366758') *\/ `vc01.pm.t1`.`id` AS `c2`, ca |\n| 353 | root | 10.0.2.101:41912 | NULL | Sleep | 667 | NULL | NULL |\n| 360 | root | 10.0.2.101:42252 | gctmpdb | Sleep | 288 | NULL | NULL |\n| 372 | root | localhost | NULL | Query | 0 | NULL | show processlist |\n+-----+------+------------------+---------+---------+------+-------+------------------------------------------------------------------------------------------------------+\n[gbase@gbase_rh7_001 cache_gbase]$<\/code><\/pre>\n\n\n\n\u5bf9\u5e94trc\u8ddf\u8e2a\u65e5\u5fd7\u91cc\u9762\u7684MAT\u90e8\u5206\u3002\u5982\u4e0b\u4f8b\u5b50\u5199\u4e861.6G\u7684MAT\u6587\u4ef6\u3002<\/p>\n\n\n\n
2021-01-27 10:48:25.981 [M: 6M, 0B,D: 0B] [DC: 79, 0] SUMMARY\n2021-01-27 10:48:25.981 [M: 6M, 0B,D: 0B] [DC: 79, 0] elapsed time: 00:02:14.024\n2021-01-27 10:48:25.981 [M: 6M, 0B,D: 0B] [DC: 79, 0] data loaded from storage: 0B, 0s, 0 DC.\n2021-01-27 10:48:25.981 [M: 6M, 0B,D: 0B] [DC: 79, 0] data decompressed: 0B, 0s.\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] temp space IO stats:\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] CB write( 0B, 0time, 0sec), read( 0B, 0time, 0sec)\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] SRT write( 0B, 0time, 0sec), read( 0B, 0time, 0sec)\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] GDC write( 0B, 0time, 0sec), read( 0B, 0time, 0sec)\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] MAT write(1.60G, 114time, 2sec), read(3.00G, 197148time, 1sec)\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] HSJ write( 0B, 0time, 0sec), read( 0B, 0time, 0sec)\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] ======================================================\n2021-01-27 10:48:25.982 [M: 6M, 0B,D: 0B] [DC: 79, 0] SUMMARY for SIS\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5728GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u4e2d\uff0c\u5982\u679c\u6570\u636e\u8fd0\u7b97\u8fc7\u7a0b\u4e2d\uff0c\u5185\u5b58\u4e0d\u8db3\u4ee5\u4fdd\u5b58\u6240\u6709\u6570\u636e\u65f6\uff0c\u4f1a\u4f7f\u7528\u78c1\u76d8\u4fdd\u5b58\u4e34\u65f6\u4e2d\u95f4\u7ed3\u679c\u3002\u672c\u6587\u4ecb\u7ecd\u8be5\u4e34\u65f6\u6570\u636e\u76ee\u5f55tmpdata\u7684\u4f5c\u7528\u548c\u8bf4\u660e\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3797","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3797","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=3797"}],"version-history":[{"count":25,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3797\/revisions"}],"predecessor-version":[{"id":4674,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3797\/revisions\/4674"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=3797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=3797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=3797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}