<\/span><\/h3>\n\n\n\n\u6570\u636e\u8d8a\u591a\uff0c\u91cf\u8d8a\u591a\uff0c\u4e0d\u5efa\u8bae\u67e5\u8be2\u660e\u7ec6\u3002 \u6ce8\u610f\u91cc\u9762\u6709\u5217(column_id)<\/p>\n\n\n\n
gbase> select * from CACHE_CELL_STATUS_INFO where table_id=118 order by dp;\r\n+----------+-----------+-----+------------+--------+--------+\r\n| TABLE_ID | COLUMN_ID | DP | LOCK_COUNT | LOCKED | SIZE |\r\n+----------+-----------+-----+------------+--------+--------+\r\n| 118 | 0 | 0 | 0 | 0 | 131084 |\r\n| 118 | 0 | 1 | 0 | 0 | 131084 |\r\n| 118 | 0 | 2 | 0 | 0 | 131084 |\r\n| 118 | 0 | 3 | 0 | 0 | 131084 |\r\n| 118 | 0 | 4 | 0 | 0 | 131084 |\r\n| 118 | 0 | 5 | 0 | 0 | 131084 |\r\n| 118 | 0 | 6 | 0 | 0 | 131084 |\r\n................\r\n| 118 | 0 | 300 | 0 | 0 | 131084 |\r\n| 118 | 0 | 301 | 0 | 0 | 131084 |\r\n| 118 | 0 | 302 | 0 | 0 | 131084 |\r\n| 118 | 0 | 303 | 0 | 0 | 131084 |\r\n| 118 | 0 | 304 | 0 | 0 | 131084 |\r\n+----------+-----------+-----+------------+--------+--------+\r\n305 rows in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u7d2f\u8ba1\u8868\u5360\u7528\u7684\u5185\u5b58<\/span><\/h3>\n\n\n\ngbase> select sum(size) from CACHE_CELL_STATUS_INFO where table_id=118;\r\n+-----------+\r\n| sum(size) |\r\n+-----------+\r\n| 39980620 |\r\n+-----------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u7efc\u5408\u4f7f\u7528<\/span><\/h3>\n\n\n\ngbase> select sum(size) from CACHE_CELL_STATUS_INFO where table_id=(select table_id from information_schema.tables where table_schema='ab' and table_name='t1_n1');\r\n+-----------+\r\n| sum(size) |\r\n+-----------+\r\n| 39980620 |\r\n+-----------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u7684\u8ba1\u7b97\u8282\u70b9\uff0c\u63d0\u4f9b\u4e86performance_schema.CACHE_CELL_STATUS_INFO\u8868\uff0c\u8bb0\u5f55\u4e86DC\u7f13\u51b2\u4fe1\u606f\uff0c\u901a\u8fc7\u7d2f\u8ba1\u5176\u5185\u5b58\u603b\u91cf\uff0c\u53ef\u4ee5\u8ba1\u7b97\u67d0\u5f20\u8868\u5360\u7528\u7684\u5185\u5b58\u70ed\u6570\u636e\u7f13\u51b2\u603b\u91cf\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":[69],"class_list":["post-8490","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-69"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8490","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=8490"}],"version-history":[{"count":2,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8490\/revisions"}],"predecessor-version":[{"id":8492,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8490\/revisions\/8492"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=8490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=8490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=8490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}