<\/span><\/h3>\n\n\n\n\u5176\u4e2d\u7684SIZE\u662f\u5360\u7528\u5927\u5c0f\uff0c\u4e0e\u524d\u9762\u6c47\u603b\u7684\u76f8\u5f53\u3002 CLASS\u662f\u5206\u7c7b(\u4e00\u4e2a\u5185\u90e8\u5185\u5b58\u5206\u914d\u6807\u8bb0\u4f4d\uff0c\u533a\u5206\u54ea\u4e9b\u7c7b\uff0c\u54ea\u4e9b\u4f4d\u7f6e\u7533\u8bf7\u4e86\u5185\u5b58\uff0c0-511. \u6bcf\u4e2a\u5206\u7c7b\uff0cCELL,LARGE,TEMP\u5404\u81ea\u72ec\u7acb)\uff0cADDR\u662f\u5185\u5b58\u5730\u5740\uff0c\u4e0d\u770b\u4e5f\u7f62\u3002INHEAP\u5982\u679c\u662f1\u5219\u8868\u793a\u4ece\u914d\u7f6e\u7684heap\u5806\u91cc\u5206\u914d\u7684\uff0c \u4e3a0\u8868\u793a\u4ece\u64cd\u4f5c\u7cfb\u7edfmalloc\u7684(\u5728\u65b0\u724895\u91cc\u4e5f\u8bb8\u6307\u8d85\u8fc7\u53c2\u6570\u8303\u56f4\u7684)\u3002<\/p>\n\n\n\n
gbase> select * from mem_detail_cell;\r\n+-------+-------+----------------+--------+\r\n| CLASS | SIZE | ADDR | INHEAP |\r\n+-------+-------+----------------+--------+\r\n| 7 | 66666 | 0x7fd504cc2008 | 1 |\r\n+-------+-------+----------------+--------+\r\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>LARGE\u5806\u5185\u5b58\u4f7f\u7528\u8be6\u60c5<\/span><\/h3>\n\n\n\n\u8fd0\u884c\u7edf\u8ba1\u65f6\u624d\u4f7f\u7528\uff0c\u4e4b\u540e\u91ca\u653e\u3002\u6ca1\u7279\u610f\u53bb\u91c7\u96c6\u3002<\/p>\n\n\n\n
gbase> select * from mem_detail_large;\r\nEmpty set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>TEMP\u5806\u5185\u5b58\u4f7f\u7528\u8be6\u60c5<\/span><\/h3>\n\n\n\ngbase> select * from mem_detail_temp;\r\n+-------+------+----------------+--------+\r\n| CLASS | SIZE | ADDR | INHEAP |\r\n+-------+------+----------------+--------+\r\n| 157 | 32 | 0x7fd489ac3008 | 1 |\r\n| 59 | 29 | 0x7fd489ac3038 | 1 |\r\n| 2 | 128 | 0x7fd489ac4008 | 1 |\r\n| 4 | 8 | 0x7fd489ac5008 | 1 |\r\n| 156 | 283 | 0x7fd489ac7008 | 1 |\r\n| 156 | 700 | 0x7fd489ac9008 | 1 |\r\n| 156 | 851 | 0x7fd489acb008 | 1 |\r\n+-------+------+----------------+--------+\r\n7 rows in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>\u7cfb\u7edf\u5185\u5b58\u6982\u51b5 MEMORY_USAGE_INFO<\/span><\/h2>\n\n\n\n<\/span>\u8bf4\u660e<\/span><\/h3>\n\n\n\n| \u5217\u540d<\/th> | \u7c7b\u578b<\/th> | \u8bf4\u660e<\/th><\/tr><\/thead> |
|---|
| HOST<\/td> | varchar(64)<\/td> | \u4e3b\u673a\u540d<\/td><\/tr> |
| PHSICAL_MEMORY<\/td> | bigint(16)<\/td> | \u7269\u7406\u5185\u5b58\u5927\u5c0f\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr> |
| SWAP_SIZE<\/td> | bigint(16)<\/td> | SWAP\u5927\u5c0f\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr> |
| PCT<\/td> | varchar(16)<\/td> | pct\u5185\u5b58\u4e0a\u9650\u8bbe\u5b9a\u53c2\u6570<\/td><\/tr> |
| UPPER_LIMIT<\/td> | bigint(16)<\/td> | \u5185\u5b58\u4e0a\u9650\u5927\u5c0f<\/td><\/tr> |
| CURRENT_USED<\/td> | bigint(16)<\/td> | \u5185\u5b58\u5f53\u524d\u4f7f\u7528\u91cf\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr> |
| MEMORY_PEAK<\/td> | bigint(16)<\/td> | \u5185\u5b58\u4f7f\u7528\u5cf0\u503c\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr> |
| MEMORY_PEAK_TIMESTAMP<\/td> | datetime<\/td> | \u5185\u5b58\u5cf0\u503c\u65f6\u7684\u65f6\u95f4<\/td><\/tr><\/tbody><\/table>GBase 8a\u6570\u636e\u5e93\u5143\u6570\u636e\u8868 \u7cfb\u7edf\u5185\u5b58\u6982\u51b5 MEMORY_USAGE_INFO<\/figcaption><\/figure>\n\n\n\n<\/span>\u6837\u4f8b<\/span><\/h3>\n\n\n\ngbase> select * from MEMORY_USAGE_INFO;\n+---------------+----------------+------------+-----+-------------+--------------+-------------+-----------------------+\n| HOST | PHSICAL_MEMORY | SWAP_SIZE | PCT | UPPER_LIMIT | CURRENT_USED | MEMORY_PEAK | MEMORY_PEAK_TIMESTAMP |\n+---------------+----------------+------------+-----+-------------+--------------+-------------+-----------------------+\n| gbase_rh7_001 | 3974889472 | 4294963200 | 80% | 6615882137 | 3623336 | 5513664 | 2021-05-12 09:55:14 |\n+---------------+----------------+------------+-----+-------------+--------------+-------------+-----------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> select * from MEMORY_USAGE_INFO\\G\n*************************** 1. row ***************************\n HOST: gbase_rh7_001\n PHSICAL_MEMORY: 3974889472\n SWAP_SIZE: 4294963200\n PCT: 80%\n UPPER_LIMIT: 6615882137\n CURRENT_USED: 3623336\n MEMORY_PEAK: 5513664\nMEMORY_PEAK_TIMESTAMP: 2021-05-12 09:55:14\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>SESSION\u7ea7\u5f53\u524d\u8fde\u63a5\u4f7f\u7528\u6982\u51b5SESSION_MEMORY_USAGE_INFO<\/span><\/h2>\n\n\n\n<\/span>\u8bf4\u660e<\/span><\/h3>\n\n\n\n| \u5217\u540d<\/th> | \u7c7b\u578b<\/th> | \u8bf4\u660e<\/th><\/tr><\/thead> |
|---|
| HOST<\/td> | varchar(64)<\/td> | \u4e3b\u673a\u540d\u5b57<\/td><\/tr> | | ID<\/td> | bigint(8)<\/td> | SESSION\u7684ID\u53f7<\/td><\/tr> | | CURRENT<\/td> | bigint(16)<\/td> | \u5f53\u524d\u4f7f\u7528\u7684\u603b\u91cf\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr> | | PEAK<\/td> | bigint(16)<\/td> | \u5cf0\u503c\u4f7f\u7528\u603b\u91cf\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr> | | PEAK_TIMESTAMP<\/td> | datetime<\/td> | \u5cf0\u503c\u4f7f\u7528\u65f6\u95f4<\/td><\/tr> | | TEMP_SPACE<\/td> | bigint(16)<\/td> | \u4e34\u65f6\u7a7a\u95f4\u4f7f\u7528\u603b\u91cf\uff0c\u5355\u4f4d\u5b57\u8282<\/td><\/tr><\/tbody><\/table>GBase 8a \u6570\u636e\u5e93\u96c6\u7fa4 SESSION\u7ea7\u5f53\u524d\u8fde\u63a5\u4f7f\u7528\u6982\u51b5SESSION_MEMORY_USAGE_INFO<\/figcaption><\/figure>\n\n\n\n<\/span>\u6837\u4f8b<\/span><\/h3>\n\n\n\ngbase> select * from SESSION_MEMORY_USAGE_INFO;\n+-------+----+---------+---------+---------------------+------------+\n| HOST | ID | CURRENT | PEAK | PEAK_TIMESTAMP | TEMP_SPACE |\n+-------+----+---------+---------+---------------------+------------+\n| rh6-2 | 9 | 17708 | 1430090 | 2021-05-11 13:45:06 | 0 |\n+-------+----+---------+---------+---------------------+------------+\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u63d0\u4f9b\u4e86\u7cfb\u7edf\u5185\u5b58\u4f7f\u7528\u4fe1\u606f\u7684\u5143\u6570\u636e\u8868\uff0c\u5176\u4e2dHEAP_USAGE_INFO\u662f\u5185\u90e8\u51e0\u4e2a\u5806\u5185\u5b58\u7684\u4f7f\u7528\u60c5\u51b5\uff0c\u5305\u62ecdc\uff0clarge\u548ctemp\uff0cMEMORY_USAGE_INFO\u8868\u5219\u662f\u8be5\u7cfb\u6b38\u4f46\u5185\u5b58\u6574\u4f53\u6982\u51b5\uff0c\u5305\u62ec\u5cf0\u503c\u548c\u51fa\u73b0\u5cf0\u503c\u7684\u65f6\u95f4\u7b49\u3002\u540c\u65f6\u5f53\u524dsession\u8fde\u63a5\u7684\u5185\u5b58\u4f7f\u7528\u4fe1\u606f\u53ef\u4ee5\u901a\u8fc7SESSION_MEMORY_USAGE_INFO\u67e5\u770b\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":[101,69,39,28],"class_list":["post-5898","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-performance_schema","tag-69","tag-39","tag-28"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5898","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=5898"}],"version-history":[{"count":21,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5898\/revisions"}],"predecessor-version":[{"id":10117,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5898\/revisions\/10117"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=5898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=5898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=5898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
|
|