{"id":5887,"date":"2021-05-12T10:11:12","date_gmt":"2021-05-12T02:11:12","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=5887"},"modified":"2021-05-12T14:39:23","modified_gmt":"2021-05-12T06:39:23","slug":"gbase-8a-%e5%86%85%e5%ad%98%e7%bc%93%e5%86%b2%e4%bf%a1%e6%81%af%e5%85%83%e6%95%b0%e6%8d%ae%e8%a1%a8cache_usage_info%e7%9a%84%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/5887","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a \u5185\u5b58\u7f13\u51b2\u4fe1\u606f\u5143\u6570\u636e\u8868CACHE_usage_info\u7684\u4ecb\u7ecd"},"content":{"rendered":"<p>GBase 8a \u63d0\u4f9b\u4e86\u67e5\u770b\u5f53\u524d\u7cfb\u7edf\u8fd0\u884c\u671f\u72b6\u51b5\u7684\u5143\u6570\u636e\u8868\uff0c\u5176\u4e2dperformance_schema.CACHE_usage_info\u8868\u5305\u542b\u4e86\u5f53\u524d\u670d\u52a1\u7684\u5185\u5b58\u7f13\u51b2\u4fe1\u606f\uff0c\u4ee5\u53ca\u6bcf\u4e2aDC\u7684\u5177\u4f53\u8be6\u60c5CACHE_CELL_STATUS_INFO\u3002\u672c\u6587\u4ecb\u7ecd\u8be5\u8868\u7684\u4f7f\u7528\u65b9\u6cd5\u3002<\/p>\n\n\n\n<p>\u8be5\u529f\u80fd\uff0c\u9700\u8981\u6253\u5f00\u6570\u636e\u5e93\u7edf\u8ba1\u5185\u5b58\u529f\u80fd\u624d\u53ef\u770b\u5230\u6570\u636e\u3002 <a href=\"https:\/\/www.gbase8.cn\/en\/5884\/\">GBase 8a\u96c6\u7fa4\u7edf\u8ba1\u8fd0\u884c\u671f\u5185\u5b58\u4f7f\u7528\u60c5\u51b5_gbase_session_memory_stat\u53c2\u6570<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2af87167407\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2af87167407\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#CACHE_usage_info_%E5%85%83%E6%95%B0%E6%8D%AE%E8%A1%A8\" >CACHE_usage_info \u5143\u6570\u636e\u8868<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E8%AF%B4%E6%98%8E\" >\u8bf4\u660e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E4%BD%BF%E7%94%A8%E6%A0%B7%E4%BE%8B\" >\u4f7f\u7528\u6837\u4f8b<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E9%BB%98%E8%AE%A4%E6%B2%A1%E6%9C%89%E7%BC%93%E5%86%B2%E6%97%B6\" >\u9ed8\u8ba4\u6ca1\u6709\u7f13\u51b2\u65f6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E6%9F%A5%E8%AF%A2%E4%B8%80%E4%B8%AA%E8%A1%A8%E5%90%8E\" >\u67e5\u8be2\u4e00\u4e2a\u8868\u540e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E5%86%8D%E6%AC%A1%E6%9F%A5%E8%AF%A2%E8%AF%A5%E8%A1%A8%E7%9A%84100%E8%A1%8C\" >\u518d\u6b21\u67e5\u8be2\u8be5\u8868\u7684100\u884c<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#DC%E8%AF%A6%E7%BB%86%E4%BF%A1%E6%81%AF%E6%BA%90%E6%95%B0%E6%8D%AE%E8%A1%A8_CACHE_CELL_STATUS_INFO\" >DC\u8be6\u7ec6\u4fe1\u606f\u6e90\u6570\u636e\u8868 CACHE_CELL_STATUS_INFO<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E8%AF%B4%E6%98%8E-2\" >\u8bf4\u660e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/5887\/#%E6%A0%B7%E4%BE%8B_%E5%A6%82%E4%B8%8B%E6%98%AF%E5%89%8D%E9%9D%A2%E7%9A%84%E5%86%85%E5%AD%98%E7%BC%93%E5%86%B2%E8%A1%A8%E6%95%B0%E6%8D%AE%EF%BC%8C%E6%AF%8F%E4%B8%AADC%E7%9A%84%E6%83%85%E5%86%B5%E4%BF%A1%E6%81%AF\" >\u6837\u4f8b \u5982\u4e0b\u662f\u524d\u9762\u7684\u5185\u5b58\u7f13\u51b2\u8868\u6570\u636e\uff0c\u6bcf\u4e2aDC\u7684\u60c5\u51b5\u4fe1\u606f<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CACHE_usage_info_%E5%85%83%E6%95%B0%E6%8D%AE%E8%A1%A8\"><\/span>CACHE_usage_info \u5143\u6570\u636e\u8868<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%B4%E6%98%8E\"><\/span>\u8bf4\u660e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u5b57\u6bb5<\/th><th>\u7c7b\u578b<\/th><th>\u8bf4\u660e<\/th><\/tr><\/thead><tbody><tr><td>HOST<\/td><td>varchar(64)<\/td><td>\u4e3b\u673a\u540d\u5b57\uff0c\u5c31\u662f\u672c\u673a<\/td><\/tr><tr><td>TOTAL_DC<\/td><td>bigint(16)<\/td><td>DC\u603b\u6570\u91cf<\/td><\/tr><tr><td>UNLOCKED_DC<\/td><td>bigint(16)<\/td><td>\u6ca1\u6709\u88ab\u9501\u4f4f\u7684DC\u603b\u6570\u91cf(\u8868\u793a\u53ef\u4ee5\u88abredlease\u91ca\u653e)<\/td><\/tr><tr><td>TOTAL_DC_SIZE<\/td><td>bigint(16)<\/td><td>DC\u5360\u7528\u603b\u5185\u5b58\u5927\u5c0f(\u5355\u4f4d:\u5b57\u8282)<\/td><\/tr><tr><td>UNLOCKED_DC_SIZE<\/td><td>bigint(16)<\/td><td>\u6ca1\u6709\u88ab\u9501\u4f4f\u7684DC\u5360\u7528\u5185\u5b58\u5927\u5c0f(\u5355\u4f4d:\u5b57\u8282)<\/td><\/tr><tr><td>HOT_TOTAL_DC<\/td><td>bigint(16)<\/td><td>\u70ed\u6570\u636eDC\u6570\u91cf<\/td><\/tr><tr><td>HOT_UNLOCKED_DC<\/td><td>bigint(16)<\/td><td>\u6ca1\u6709\u88ab\u9501\u4f4f\u7684\u70ed\u6570\u636eDC\u6570\u91cf<\/td><\/tr><tr><td>HOT_TOTAL_DC_SIZE<\/td><td>bigint(16)<\/td><td>\u70ed\u6570\u636eDC\u5360\u7528\u603b\u5185\u5b58\u5927\u5c0f(\u5355\u4f4d:\u5b57\u8282)<\/td><\/tr><tr><td>HOT_UNLOCKED_DC_SIZE<\/td><td>bigint(16)<\/td><td>\u6ca1\u6709\u88ab\u9501\u4f4f\u7684\u70ed\u6570\u636eDC\u5360\u7528\u5185\u5b58\u5927\u5c0f(\u5355\u4f4d:\u5b57\u8282)<\/td><\/tr><tr><td>COLD_TOTAL_DC<\/td><td>bigint(16)<\/td><td>\u51b7\u6570\u636eDC\u6570\u91cf<\/td><\/tr><tr><td>COLD_UNLOCKED_DC<\/td><td>bigint(16)<\/td><td>\u6ca1\u6709\u88ab\u9501\u4f4f\u7684\u51b7\u6570\u636eDC\u6570\u91cf<\/td><\/tr><tr><td>COLD_TOTAL_DC_SIZE<\/td><td>bigint(16)<\/td><td>\u51b7\u6570\u636eDC\u5360\u7528\u603b\u5185\u5b58\u5927\u5c0f(\u5355\u4f4d:\u5b57\u8282)<\/td><\/tr><tr><td>COLD_UNLOCKED_DC_SIZE<\/td><td>bigint(16)<\/td><td>\u6ca1\u6709\u88ab\u9501\u4f4f\u7684\u51b7\u6570\u636eDC\u5360\u7528\u5185\u5b58\u5927\u5c0f(\u5355\u4f4d:\u5b57\u8282)<\/td><\/tr><tr><td>HIT_RATE<\/td><td>varchar(16)<\/td><td>DC\u547d\u4e2d\u7387<\/td><\/tr><tr><td><\/td><td><\/td><td><\/td><\/tr><\/tbody><\/table><figcaption>performance_schema.cache_usage_info \u5185\u5b58\u7f13\u51b2\u4fe1\u606f\u5143\u6570\u636e\u8868<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BD%BF%E7%94%A8%E6%A0%B7%E4%BE%8B\"><\/span>\u4f7f\u7528\u6837\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%BB%98%E8%AE%A4%E6%B2%A1%E6%9C%89%E7%BC%93%E5%86%B2%E6%97%B6\"><\/span>\u9ed8\u8ba4\u6ca1\u6709\u7f13\u51b2\u65f6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u5168\u90e8\u6570\u503c\u4e3a0<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from CACHE_usage_info;\n+-------+----------+-------------+---------------+------------------+--------------+-----------------+-------------------+----------------------+---------------+------------------+--------------------+-----------------------+----------+\n| HOST  | TOTAL_DC | UNLOCKED_DC | TOTAL_DC_SIZE | UNLOCKED_DC_SIZE | HOT_TOTAL_DC | HOT_UNLOCKED_DC | HOT_TOTAL_DC_SIZE | HOT_UNLOCKED_DC_SIZE | COLD_TOTAL_DC | COLD_UNLOCKED_DC | COLD_TOTAL_DC_SIZE | COLD_UNLOCKED_DC_SIZE | HIT_RATE |\n+-------+----------+-------------+---------------+------------------+--------------+-----------------+-------------------+----------------------+---------------+------------------+--------------------+-----------------------+----------+\n| rh6-2 |        0 |           0 |             0 |                0 |            0 |               0 |                 0 |                    0 |             0 |                0 |                  0 |                     0 | 100%     |\n+-------+----------+-------------+---------------+------------------+--------------+-----------------+-------------------+----------------------+---------------+------------------+--------------------+-----------------------+----------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9F%A5%E8%AF%A2%E4%B8%80%E4%B8%AA%E8%A1%A8%E5%90%8E\"><\/span>\u67e5\u8be2\u4e00\u4e2a\u8868\u540e<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u8be5\u8868\u670950\u4e07\u884c\uff0c8\u4e2aDC\uff08\u6bcf\u4e2aDC 65536\u884c)\u3002\u53ef\u4ee5\u770b\u5230\u7f13\u51b2\u7684DC\u6570\u91cf\u4e3a8. \u547d\u4e2d\u738730%\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from testdb.t1_n1;\n+-------+------+\n| id    | name |\n+-------+------+\n|   222 | NULL |\n|  5105 | NULL |\n| 18263 | NULL |\n| 16969 | NULL |\n\n|  6116 | NULL |\n^C| 13664 | Query aborted by Ctrl+C\nNULL |\n+-------+------+\n500001 rows in set (Elapsed: 00:00:00.61)\n\ngbase&gt; select * from CACHE_usage_info;\nERROR 1317 (70100): Query execution was interrupted\ngbase&gt; select * from CACHE_usage_info;\n+-------+----------+-------------+---------------+------------------+--------------+-----------------+-------------------+----------------------+---------------+------------------+--------------------+-----------------------+----------+\n| HOST  | TOTAL_DC | UNLOCKED_DC | TOTAL_DC_SIZE | UNLOCKED_DC_SIZE | HOT_TOTAL_DC | HOT_UNLOCKED_DC | HOT_TOTAL_DC_SIZE | HOT_UNLOCKED_DC_SIZE | COLD_TOTAL_DC | COLD_UNLOCKED_DC | COLD_TOTAL_DC_SIZE | COLD_UNLOCKED_DC_SIZE | HIT_RATE |\n+-------+----------+-------------+---------------+------------------+--------------+-----------------+-------------------+----------------------+---------------+------------------+--------------------+-----------------------+----------+\n| rh6-2 |        8 |           8 |       1000098 |          1000098 |            8 |               8 |           1000098 |              1000098 |             0 |                0 |                  0 |                     0 | 30%      |\n+-------+----------+-------------+---------------+------------------+--------------+-----------------+-------------------+----------------------+---------------+------------------+--------------------+-----------------------+----------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select * from CACHE_usage_info\\G;\n*************************** 1. row ***************************\n                 HOST: rh6-2\n             TOTAL_DC: 8\n          UNLOCKED_DC: 8\n        TOTAL_DC_SIZE: 1000098\n     UNLOCKED_DC_SIZE: 1000098\n         HOT_TOTAL_DC: 8\n      HOT_UNLOCKED_DC: 8\n    HOT_TOTAL_DC_SIZE: 1000098\n HOT_UNLOCKED_DC_SIZE: 1000098\n        COLD_TOTAL_DC: 0\n     COLD_UNLOCKED_DC: 0\n   COLD_TOTAL_DC_SIZE: 0\nCOLD_UNLOCKED_DC_SIZE: 0\n             HIT_RATE: 30%\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%86%8D%E6%AC%A1%E6%9F%A5%E8%AF%A2%E8%AF%A5%E8%A1%A8%E7%9A%84100%E8%A1%8C\"><\/span>\u518d\u6b21\u67e5\u8be2\u8be5\u8868\u7684100\u884c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u547d\u4e2d\u7387\u589e\u52a0\u5230\u4e8636.36%\uff0c\u5168\u90e8\u662f\u70ed\u6570\u636e\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from testdb.t1_n1 limit 100;\n+-------+------+\n| id    | name |\n+-------+------+\n|   222 | NULL |\n\u3002\u3002\u3002\u3002\u3002\u3002\n| 23793 | NULL |\n+-------+------+\n100 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select * from CACHE_usage_info\\G;\n*************************** 1. row ***************************\n                 HOST: rh6-2\n             TOTAL_DC: 8\n          UNLOCKED_DC: 8\n        TOTAL_DC_SIZE: 1000098\n     UNLOCKED_DC_SIZE: 1000098\n         HOT_TOTAL_DC: 8\n      HOT_UNLOCKED_DC: 8\n    HOT_TOTAL_DC_SIZE: 1000098\n HOT_UNLOCKED_DC_SIZE: 1000098\n        COLD_TOTAL_DC: 0\n     COLD_UNLOCKED_DC: 0\n   COLD_TOTAL_DC_SIZE: 0\nCOLD_UNLOCKED_DC_SIZE: 0\n             HIT_RATE: 36.36%\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DC%E8%AF%A6%E7%BB%86%E4%BF%A1%E6%81%AF%E6%BA%90%E6%95%B0%E6%8D%AE%E8%A1%A8_CACHE_CELL_STATUS_INFO\"><\/span>DC\u8be6\u7ec6\u4fe1\u606f\u6e90\u6570\u636e\u8868 CACHE_CELL_STATUS_INFO<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%B4%E6%98%8E-2\"><\/span>\u8bf4\u660e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u5b57\u6bb5<\/th><th>\u7c7b\u578b<\/th><th>\u8bf4\u660e<\/th><\/tr><\/thead><tbody><tr><td>TABLE_ID<\/td><td>bigint(16)<\/td><td>\u8868\u7f16\u53f7\uff08<a href=\"https:\/\/www.gbase8.cn\/en\/1845\/\">GBase 8a\u67e5\u770b\u8868\u7684tableId<\/a>)<\/td><\/tr><tr><td>COLUMN_ID<\/td><td>bigint(16)<\/td><td>\u5217\u7f16\u53f7,\u4ece0\u5f00\u59cb<\/td><\/tr><tr><td>DP<\/td><td>bigint(16)<\/td><td>DC\u7684\u4f4d\u7f6e\uff0c\u4ece0\u5f00\u59cb<\/td><\/tr><tr><td>LOCK_COUNT<\/td><td>bigint(16)<\/td><td>\u88ab\u9501\u7684\u6b21\u6570<\/td><\/tr><tr><td>LOCKED<\/td><td>bigint(16)<\/td><td>\u9501\u4f4f\u72b6\u6001\uff0c1=\u662f\uff0c0=\u5426<\/td><\/tr><tr><td>SIZE<\/td><td>bigint(16)<\/td><td>\u5360\u7528\u5185\u5b58\u5927\u5c0f<\/td><\/tr><\/tbody><\/table><figcaption>GBase 8a\u96c6\u7fa4DC\u8be6\u7ec6\u4fe1\u606f\u6e90\u6570\u636e\u8868 CACHE_CELL_STATUS_INFO<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%A0%B7%E4%BE%8B_%E5%A6%82%E4%B8%8B%E6%98%AF%E5%89%8D%E9%9D%A2%E7%9A%84%E5%86%85%E5%AD%98%E7%BC%93%E5%86%B2%E8%A1%A8%E6%95%B0%E6%8D%AE%EF%BC%8C%E6%AF%8F%E4%B8%AADC%E7%9A%84%E6%83%85%E5%86%B5%E4%BF%A1%E6%81%AF\"><\/span>\u6837\u4f8b<br>\u5982\u4e0b\u662f\u524d\u9762\u7684\u5185\u5b58\u7f13\u51b2\u8868\u6570\u636e\uff0c\u6bcf\u4e2aDC\u7684\u60c5\u51b5\u4fe1\u606f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase> select * from CACHE_CELL_STATUS_INFO;\r\n+----------+-----------+----+------------+--------+--------+\r\n| TABLE_ID | COLUMN_ID | DP | LOCK_COUNT | LOCKED | SIZE   |\r\n+----------+-----------+----+------------+--------+--------+\r\n|   243717 |         0 |  6 |          0 |      0 | 131084 |\r\n|   243717 |         0 |  7 |          0 |      0 |  82510 |\r\n|   243717 |         0 |  3 |          0 |      0 | 131084 |\r\n|   243717 |         0 |  2 |          0 |      0 | 131084 |\r\n|   243717 |         0 |  5 |          0 |      0 | 131084 |\r\n|   243717 |         0 |  1 |          0 |      0 | 131084 |\r\n|   243717 |         0 |  4 |          0 |      0 | 131084 |\r\n|   243717 |         0 |  0 |          0 |      0 | 131084 |\r\n+----------+-----------+----+------------+--------+--------+\r\n8 rows in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a \u63d0\u4f9b\u4e86\u67e5\u770b\u5f53\u524d\u7cfb\u7edf\u8fd0\u884c\u671f\u72b6\u51b5\u7684\u5143\u6570\u636e\u8868\uff0c\u5176\u4e2dperformance_schema.CACHE_usage_info\u8868\u5305\u542b\u4e86\u5f53\u524d\u670d\u52a1\u7684\u5185\u5b58\u7f13\u51b2\u4fe1\u606f\uff0c\u4ee5\u53ca\u6bcf\u4e2aDC\u7684\u5177\u4f53\u8be6\u60c5CACHE_CELL_STATUS_INFO\u3002\u672c\u6587\u4ecb\u7ecd\u8be5\u8868\u7684\u4f7f\u7528\u65b9\u6cd5<\/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,51,28],"class_list":["post-5887","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-performance_schema","tag-69","tag-39","tag-51","tag-28"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5887","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=5887"}],"version-history":[{"count":6,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5887\/revisions"}],"predecessor-version":[{"id":5897,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5887\/revisions\/5897"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=5887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=5887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=5887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}