{"id":37262,"date":"2025-05-15T07:26:06","date_gmt":"2025-05-14T23:26:06","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/37262.html"},"modified":"2025-05-15T07:26:06","modified_gmt":"2025-05-14T23:26:06","slug":"mysql%e4%b9%8b%e6%9c%8d%e5%8a%a1%e5%99%a8%e7%8a%b6%e6%80%81%e6%8c%87%e6%a0%87%e6%b7%b1%e5%ba%a6%e8%a7%a3%e6%9e%90%e4%b8%8e%e6%80%a7%e8%83%bd%e8%b0%83%e4%bc%98%e5%ae%9e%e6%88%98","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/37262.html","title":{"rendered":"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218"},"content":{"rendered":"

Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218<\/h2>\n

\u4e00\u3001\u524d\u8a00<\/h3>\n

\u5f00\u53d1\u8005\u670b\u53cb\u4eec，\u5728MySQL\u6570\u636e\u5e93\u7684\u65e5\u5e38\u8fd0\u7ef4\u4e2d，\u6df1\u5165\u7406\u89e3\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u662f\u6027\u80fd\u4f18\u5316\u548c\u6545\u969c\u6392\u67e5\u7684\u6838\u5fc3\u80fd\u529b\u3002\u8fd9\u4e9b\u6307\u6807\u5982\u540c\u6570\u636e\u5e93\u7684\u201c\u5065\u5eb7\u4eea\u8868\u76d8\u201d，\u80fd\u5b9e\u65f6\u53cd\u6620\u7cfb\u7edf\u7684\u8fd0\u884c\u72b6\u6001\u3001\u8d44\u6e90\u4f7f\u7528\u60c5\u51b5\u53ca\u6f5c\u5728\u95ee\u9898\u3002\u5199\u4f5c\u672c\u6587\u7684\u521d\u8877，\u662f\u5e0c\u671b\u4e0e\u5927\u5bb6\u4e00\u540c\u5b66\u4e60\u8fdb\u6b65，\u901a\u8fc7\u89e3\u6790\u6838\u5fc3\u72b6\u6001\u6307\u6807\u3001\u6f14\u793a\u67e5\u8be2\u65b9\u6cd5\u53ca\u5b9e\u6218\u8c03\u4f18\u6848\u4f8b，\u5e2e\u52a9\u5927\u5bb6\u638c\u63e1\u4ece\u6307\u6807\u76d1\u63a7\u5230\u95ee\u9898\u89e3\u51b3\u7684\u5b8c\u6574\u6d41\u7a0b，\u63d0\u5347\u6570\u636e\u5e93\u7ba1\u7406\u7684\u6548\u7387\u4e0e\u7cbe\u51c6\u5ea6\u3002<\/p>\n

\u4e8c\u3001\u6838\u5fc3\u72b6\u6001\u6307\u6807\u5206\u7c7b\u4e0e\u89e3\u6790<\/h3>\n

（\u4e00）\u8fde\u63a5\u4e0e\u7ebf\u7a0b\u7ba1\u7406\u6307\u6807<\/h4>\n

1. \u5173\u952e\u6307\u6807\u8bf4\u660e<\/h5>\n\n\u6307\u6807\u540d\u542b\u4e49\u5065\u5eb7\u9608\u503c\u5f02\u5e38\u6392\u67e5\u65b9\u5411<\/tr>\n\n\n\n\n\n
Connections<\/td>\n\u5c1d\u8bd5\u8fde\u63a5\u603b\u6570<\/td>\n\u65e0\u56fa\u5b9a\u9608\u503c，\u9700\u7ed3\u5408max_connections<\/td>\n\u82e5\u6fc0\u589e，\u68c0\u67e5\u5e94\u7528\u8fde\u63a5\u6c60\u914d\u7f6e\u6216\u6076\u610f\u653b\u51fb<\/td>\n<\/tr>\n
Threads_connected<\/td>\n\u5f53\u524d\u6d3b\u52a8\u8fde\u63a5\u6570<\/td>\n< 80% of max_connections<\/td>\n\u63a5\u8fd1\u9608\u503c\u65f6，\u4f18\u5316\u8fde\u63a5\u590d\u7528\u6216\u589e\u52a0max_connections<\/td>\n<\/tr>\n
Aborted_connects<\/td>\n\u8fde\u63a5\u5931\u8d25\u6570<\/td>\n<10\u6b21\/\u5c0f\u65f6<\/td>\n\u7f51\u7edc\u4e0d\u7a33\u5b9a\u3001\u5bc6\u7801\u9519\u8bef\u6216\u9632\u706b\u5899\u62e6\u622a<\/td>\n<\/tr>\n
Threads_created<\/td>\n\u521b\u5efa\u7ebf\u7a0b\u603b\u6570<\/td>\n\u5e94\u5c3d\u53ef\u80fd\u5c0f（\u7406\u60f3\u4e3a0）<\/td>\n\u6570\u503c\u5927\u8868\u660e\u7ebf\u7a0b\u91cd\u7528\u7387\u4f4e，\u8c03\u6574thread_cache_size<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
2. \u67e5\u8be2\u793a\u4f8b<\/h5>\n

— \u67e5\u770b\u5f53\u524d\u8fde\u63a5\u6570\u4e0e\u6700\u5927\u8fde\u63a5\u6570\u6bd4\u4f8b<\/span>
\nSELECT<\/span>
\n Threads_connected,<\/span>
\n max_connections,<\/span>
\n CONCAT(<\/span>ROUND<\/span>(<\/span>Threads_connected\/<\/span>max_connections*<\/span>100<\/span>,<\/span> 2<\/span>)<\/span>,<\/span> '%'<\/span>)<\/span> AS<\/span> usage_percent
\nFROM<\/span> INFORMATION_SCHEMA.<\/span>GLOBAL_STATUS;<\/span><\/p>\n

（\u4e8c）\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e0e\u4e8b\u52a1\u6307\u6807<\/h4>\n

1. \u5173\u952e\u6307\u6807\u8bf4\u660e<\/h5>\n\n\u6307\u6807\u540d\u542b\u4e49\u4f18\u5316\u65b9\u5411<\/tr>\n\n\n\n\n
Binlog_cache_use<\/td>\n\u4f7f\u7528\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7f13\u5b58\u7684\u4e8b\u52a1\u6570<\/td>\n\u82e5Binlog_cache_disk_use\u9ad8，\u589e\u5927binlog_cache_size<\/td>\n<\/tr>\n
Binlog_cache_disk_use<\/td>\n\u56e0\u7f13\u5b58\u4e0d\u8db3\u5199\u5165\u78c1\u76d8\u7684\u4e8b\u52a1\u6570<\/td>\n\u76ee\u6807：\u5c3d\u53ef\u80fd\u4e3a0<\/td>\n<\/tr>\n
Com_commit\/Com_rollback<\/td>\n\u63d0\u4ea4\/\u56de\u6eda\u4e8b\u52a1\u6570<\/td>\n\u9ad8\u56de\u6eda\u7387\u53ef\u80fd\u8868\u660e\u4e1a\u52a1\u903b\u8f91\u95ee\u9898<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
2. \u8c03\u4f18\u5b9e\u8df5<\/h5>\n

— \u8c03\u6574\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7f13\u5b58\u5927\u5c0f（\u9700\u91cd\u542f\u751f\u6548）<\/span>
\nSET<\/span> GLOBAL<\/span> binlog_cache_size =<\/span> 64<\/span>K;<\/span>
\n— \u67e5\u770b\u7f13\u5b58\u4f7f\u7528\u60c5\u51b5<\/span>
\nSHOW<\/span> GLOBAL<\/span> STATUS<\/span> LIKE<\/span> 'Binlog_cache%'<\/span>;<\/span><\/p>\n

（\u4e09）\u67e5\u8be2\u4e0e\u4e34\u65f6\u8868\u6307\u6807<\/h4>\n

1. \u5173\u952e\u6307\u6807\u8bf4\u660e<\/h5>\n\n\u6307\u6807\u540d\u542b\u4e49\u5065\u5eb7\u9608\u503c<\/tr>\n\n\n\n\n
Created_tmp_tables<\/td>\n\u5185\u90e8\u521b\u5efa\u7684\u4e34\u65f6\u8868\u6570<\/td>\n<= 100\u6b21\/\u5c0f\u65f6<\/td>\n<\/tr>\n
Created_tmp_disk_tables<\/td>\n\u4e34\u65f6\u8868\u5199\u5165\u78c1\u76d8\u6570<\/td>\n< 5% of Created_tmp_tables<\/td>\n<\/tr>\n
Select_scan<\/td>\n\u5168\u8868\u626b\u63cf\u6b21\u6570<\/td>\n\u5e94\u5c3d\u53ef\u80fd\u4f4e（\u7406\u60f3<1% of Com_select）<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
2. \u5168\u8868\u626b\u63cf\u4f18\u5316<\/h5>\n

— \u5b9a\u4f4d\u5168\u8868\u626b\u63cf\u67e5\u8be2（\u6162\u67e5\u8be2\u65e5\u5fd7\u5206\u6790）<\/span>
\nSELECT<\/span> query_text
\nFROM<\/span> slow_log
\nWHERE<\/span> query_text LIKE<\/span> 'SELECT % FROM % WHERE %'<\/span>
\nAND<\/span> NOT<\/span> LIKE<\/span> '%INDEX%'<\/span>;<\/span><\/p>\n

（\u56db）\u5b58\u50a8\u5f15\u64ce\u76f8\u5173\u6307\u6807<\/h4>\n

1. InnoDB\u6838\u5fc3\u6307\u6807<\/h5>\n\n\u6307\u6807\u540d\u542b\u4e49\u4f18\u5316\u65b9\u5411<\/tr>\n\n\n\n\n
Innodb_buffer_pool_hit_rate<\/td>\n\u7f13\u51b2\u6c60\u547d\u4e2d\u7387<\/td>\n>90%<\/td>\n<\/tr>\n
Innodb_rows_read\/Innodb_rows_written<\/td>\n\u6570\u636e\u8bfb\u5199\u884c\u6570<\/td>\n\u7ed3\u5408\u4e1a\u52a1\u8bc4\u4f30，\u65e0\u56fa\u5b9a\u9608\u503c<\/td>\n<\/tr>\n
Innodb_lock_waits<\/td>\n\u9501\u7b49\u5f85\u6b21\u6570<\/td>\n\u5e94\u5c3d\u53ef\u80fd\u4f4e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
2. MyISAM\u952e\u7f13\u5b58\u6307\u6807<\/h5>\n

— \u952e\u7f13\u5b58\u547d\u4e2d\u7387\u8ba1\u7b97<\/span>
\nSELECT<\/span>
\n (<\/span>Key_read_requests –<\/span> Key_reads)<\/span> \/<\/span> Key_read_requests *<\/span> 100<\/span> AS<\/span> key_cache_hit_rate
\nFROM<\/span> INFORMATION_SCHEMA.<\/span>GLOBAL_STATUS;<\/span><\/p>\n

\u4e09\u3001\u5b9e\u6218\u573a\u666f：\u4ece\u6307\u6807\u5f02\u5e38\u5230\u95ee\u9898\u89e3\u51b3<\/h3>\n

（\u4e00）\u573a\u666f1：\u8fde\u63a5\u6570\u98d9\u5347\u5bfc\u81f4\u670d\u52a1\u4e0d\u53ef\u7528<\/h4>\n

1. \u6307\u6807\u53d1\u73b0<\/h5>\n
    \n
  • Threads_connected\u7a81\u7834max_connections（\u8bbe\u7f6e\u4e3a2000），Aborted_connects\u6fc0\u589e\u3002<\/li>\n
  • \u5e94\u7528\u7aef\u62a5\u9519\u201cToo many connections\u201d\u3002<\/li>\n<\/ul>\n
    2. \u6392\u67e5\u6b65\u9aa4<\/h5>\n

    — \u67e5\u770b\u8fde\u63a5\u6765\u6e90\u5206\u5e03<\/span>
    \nSELECT<\/span>
    \n SUBSTRING_INDEX(<\/span>HOST,<\/span> ':'<\/span>,<\/span> 1<\/span>)<\/span> AS<\/span> client_ip,<\/span>
    \n COUNT<\/span>(<\/span>*<\/span>)<\/span> AS<\/span> connection_count
    \nFROM<\/span> INFORMATION_SCHEMA.<\/span>PROCESSLIST
    \nGROUP<\/span> BY<\/span> client_ip
    \nORDER<\/span> BY<\/span> connection_count DESC<\/span> LIMIT<\/span> 5<\/span>;<\/span><\/p>\n

      \n
    • \u53d1\u73b0\u67d0IP\u77ed\u65f6\u95f4\u5185\u521b\u5efa\u5927\u91cf\u8fde\u63a5，\u7591\u4f3c\u8fde\u63a5\u6c60\u6cc4\u6f0f\u3002<\/li>\n<\/ul>\n
      3. \u89e3\u51b3\u65b9\u6848<\/h5>\n
        \n
      • \u5e94\u7528\u4fa7\u4fee\u590d\u8fde\u63a5\u6c60\u914d\u7f6e，\u9650\u5236\u6700\u5927\u8fde\u63a5\u6570\u3002<\/li>\n
      • \u4e34\u65f6\u8c03\u6574MySQL\u53c2\u6570：SET<\/span> GLOBAL<\/span> max_connections =<\/span> 3000<\/span>;<\/span> — \u4e34\u65f6\u6269\u5927\u8fde\u63a5\u4e0a\u9650<\/span>
        \nSET<\/span> GLOBAL<\/span> thread_cache_size =<\/span> 50<\/span>;<\/span> — \u589e\u52a0\u7ebf\u7a0b\u7f13\u5b58\u6570<\/span>\n <\/li>\n<\/ul>\n

        （\u4e8c）\u573a\u666f2：\u4e3b\u4ece\u590d\u5236\u5ef6\u8fdf\u8fc7\u9ad8<\/h4>\n

        1. \u6307\u6807\u53d1\u73b0<\/h5>\n
          \n
        • Seconds_Behind_Master\u6301\u7eed>30\u79d2，Slave_IO_Running\u548cSlave_SQL_Running\u5747\u4e3aYes\u3002<\/li>\n
        • SHOW SLAVE STATUS\u663e\u793aLast_Executed_Log_Pos\u505c\u6ede\u3002<\/li>\n<\/ul>\n
          2. \u6df1\u5ea6\u5206\u6790<\/h5>\n

          # \u4f7f\u7528innotop\u67e5\u770b\u4ece\u5e93SQL\u7ebf\u7a0b\u6267\u884c\u7684SQL<\/span>
          \ninnotop -M # \u8fdb\u5165\u590d\u5236\u6a21\u5f0f，\u89c2\u5bdf\u6b63\u5728\u6267\u884c\u7684\u4e8b\u52a1<\/span><\/p>\n

            \n
          • \u53d1\u73b0\u4ece\u5e93\u5728\u6267\u884c\u4e00\u4e2a\u8017\u65f6\u7684\u5927\u8868\u66f4\u65b0\u64cd\u4f5c，\u5bfc\u81f4\u590d\u5236\u5ef6\u8fdf\u3002<\/li>\n<\/ul>\n
            3. \u4f18\u5316\u63aa\u65bd<\/h5>\n
              \n
            • \u4e3b\u5e93\u62c6\u5206\u5927\u4e8b\u52a1\u4e3a\u6279\u91cf\u64cd\u4f5c（\u5982\u6bcf\u6b21\u66f4\u65b01000\u884c）\u3002<\/li>\n
            • \u4ece\u5e93\u542f\u7528\u5e76\u884c\u590d\u5236（MySQL 5.7+）：SET<\/span> GLOBAL<\/span> slave_parallel_workers =<\/span> 4<\/span>;<\/span>
              \nSET<\/span> GLOBAL<\/span> slave_parallel_type =<\/span> 'LOGICAL_CLOCK'<\/span>;<\/span>\n <\/li>\n<\/ul>\n

              （\u4e09）\u573a\u666f3：\u4e34\u65f6\u8868\u5199\u5165\u78c1\u76d8\u8fc7\u9ad8<\/h4>\n

              1. \u6307\u6807\u53d1\u73b0<\/h5>\n
                \n
              • Created_tmp_disk_tables\u5360\u6bd4Created_tmp_tables\u768430%，\u8fdc\u8d85\u5065\u5eb7\u9608\u503c（<5%）\u3002<\/li>\n<\/ul>\n
                2. \u5b9a\u4f4d\u67e5\u8be2<\/h5>\n

                — \u67e5\u8be2\u5bfc\u81f4\u4e34\u65f6\u8868\u7684SQL<\/span>
                \nSELECT<\/span>
                \n PROCESSLIST.<\/span>ID,<\/span>
                \n PROCESSLIST.<\/span>INFO AS<\/span> query_text,<\/span>
                \n TEMP_TABLES.<\/span>DISK_TABLES
                \nFROM<\/span> INFORMATION_SCHEMA.<\/span>PROCESSLIST
                \nJOIN<\/span> (<\/span>SELECT<\/span> THREAD_ID,<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> AS<\/span> DISK_TABLES
                \n FROM<\/span> INFORMATION_SCHEMA.<\/span>TEMPORARY_TABLES
                \n GROUP<\/span> BY<\/span> THREAD_ID)<\/span> AS<\/span> TEMP_TABLES
                \nON<\/span> PROCESSLIST.<\/span>ID =<\/span> TEMP_TABLES.<\/span>THREAD_ID
                \nWHERE<\/span> DISK_TABLES ><\/span> 0<\/span>;<\/span><\/p>\n

                  \n
                • \u53d1\u73b0\u67d0\u7edf\u8ba1\u67e5\u8be2\u56e0\u7f3a\u5c11\u7d22\u5f15\u5bfc\u81f4\u4e34\u65f6\u8868\u8fc7\u5927\u3002<\/li>\n<\/ul>\n
                  3. \u4f18\u5316\u65b9\u6848<\/h5>\n
                    \n
                  • \u4e3a\u67e5\u8be2\u6761\u4ef6\u6dfb\u52a0\u7d22\u5f15：ALTER<\/span> TABLE<\/span> sales ADD<\/span> INDEX<\/span> idx_date_user (<\/span>sale_date,<\/span> user_id)<\/span>;<\/span>\n <\/li>\n
                  • \u8c03\u6574\u4e34\u65f6\u8868\u5185\u5b58\u5927\u5c0f：SET<\/span> GLOBAL<\/span> tmp_table_size =<\/span> 128<\/span>M;<\/span>
                    \nSET<\/span> GLOBAL<\/span> max_heap_table_size =<\/span> 128<\/span>M;<\/span>\n <\/li>\n<\/ul>\n

                    \u56db\u3001\u81ea\u52a8\u5316\u76d1\u63a7\u4e0e\u6307\u6807\u91c7\u96c6<\/h3>\n

                    （\u4e00）\u811a\u672c\u5316\u91c7\u96c6\u5173\u952e\u6307\u6807（Python\u793a\u4f8b）<\/h4>\n

                    import<\/span> mysql.<\/span>connector
                    \nfrom<\/span> datetime import<\/span> datetime<\/p>\n

                    def<\/span> monitor_mysql_status<\/span>(<\/span>host,<\/span> user,<\/span> password)<\/span>:<\/span>
                    \n config =<\/span> {<\/span>
                    \n "host"<\/span>:<\/span> host,<\/span>
                    \n "user"<\/span>:<\/span> user,<\/span>
                    \n "password"<\/span>:<\/span> password,<\/span>
                    \n "database"<\/span>:<\/span> "information_schema"<\/span>
                    \n }<\/span>
                    \n conn =<\/span> mysql.<\/span>connector.<\/span>connect(<\/span>**<\/span>config)<\/span>
                    \n cursor =<\/span> conn.<\/span>cursor(<\/span>)<\/span><\/p>\n

                    # \u91c7\u96c6\u8fde\u63a5\u6307\u6807<\/span>
                    \n cursor.<\/span>execute(<\/span>"SELECT VARIABLE_VALUE FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_connected'"<\/span>)<\/span>
                    \n threads_connected =<\/span> int<\/span>(<\/span>cursor.<\/span>fetchone(<\/span>)<\/span>[<\/span>0<\/span>]<\/span>)<\/span><\/p>\n

                    # \u91c7\u96c6InnoDB\u7f13\u51b2\u6c60\u547d\u4e2d\u7387<\/span>
                    \n cursor.<\/span>execute(<\/span>"SELECT VARIABLE_VALUE FROM GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_buffer_pool_hit_rate'"<\/span>)<\/span>
                    \n hit_rate =<\/span> int<\/span>(<\/span>cursor.<\/span>fetchone(<\/span>)<\/span>[<\/span>0<\/span>]<\/span>)<\/span><\/p>\n

                    conn.<\/span>close(<\/span>)<\/span>
                    \n print<\/span>(<\/span>f"[<\/span>{<\/span>datetime.<\/span>now(<\/span>)<\/span>}<\/span><\/span>] \u8fde\u63a5\u6570: <\/span>{<\/span>threads_connected}<\/span><\/span>, \u7f13\u51b2\u6c60\u547d\u4e2d\u7387: <\/span>{<\/span>hit_rate}<\/span><\/span>%"<\/span><\/span>)<\/span><\/p>\n

                    if<\/span> __name__ ==<\/span> "__main__"<\/span>:<\/span>
                    \n monitor_mysql_status(<\/span>"localhost"<\/span>,<\/span> "root"<\/span>,<\/span> "your_password"<\/span>)<\/span><\/p>\n

                    （\u4e8c）Prometheus+Grafana\u53ef\u89c6\u5316<\/h4>\n

                    1. \u914d\u7f6emysqld_exporter<\/h5>\n

                    # prometheus.yml<\/span>
                    \nscrape_configs<\/span>:<\/span>
                    \n –<\/span> job_name<\/span>:<\/span> 'mysql'<\/span>
                    \n static_configs<\/span>:<\/span>
                    \n –<\/span> targets<\/span>:<\/span> [<\/span>'localhost:9104'<\/span>]<\/span>
                    \n metrics_path<\/span>:<\/span> \/metrics
                    \n params<\/span>:<\/span>
                    \n collect[<\/span>]<\/span>:<\/span> [<\/span>'global_status'<\/span>,<\/span> 'innodb_metrics'<\/span>]<\/span><\/p>\n

                    2. Grafana\u4eea\u8868\u76d8\u793a\u4f8b<\/h5>\n

                    \"\u5916\u94fe\u56fe\u7247\u8f6c\u5b58\u5931\u8d25,\u6e90\u7ad9\u53ef\u80fd\u6709\u9632\u76d7\u94fe\u673a\u5236,\u5efa\u8bae\u5c06\u56fe\u7247\u4fdd\u5b58\u4e0b\u6765\u76f4\u63a5\u4e0a\u4f20\" \u5c55\u793a\u6307\u6807：QPS\u8d8b\u52bf\u3001\u8fde\u63a5\u6570\u3001\u7f13\u51b2\u6c60\u547d\u4e2d\u7387\u3001\u4e3b\u4ece\u5ef6\u8fdf\u3002<\/p>\n

                    \u4e94\u3001\u603b\u7ed3：\u6307\u6807\u9a71\u52a8\u7684\u4f18\u5316\u65b9\u6cd5\u8bba<\/h3>\n

                    \u672c\u6587\u56f4\u7ed5MySQL\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807，\u89e3\u6790\u4e86\u6838\u5fc3\u5206\u7c7b\u3001\u67e5\u8be2\u65b9\u6cd5\u53ca\u5b9e\u6218\u8c03\u4f18\u7b56\u7565，\u6838\u5fc3\u65b9\u6cd5\u8bba\u5982\u4e0b：<\/p>\n

                  • \u5efa\u7acb\u57fa\u7ebf：\u901a\u8fc7\u5386\u53f2\u6570\u636e\u786e\u5b9a\u5404\u6307\u6807\u7684\u6b63\u5e38\u8303\u56f4（\u5982QPS\u5cf0\u503c\u3001\u8fde\u63a5\u6570\u6ce2\u52a8\u533a\u95f4）\u3002<\/li>\n
                  • \u5206\u5c42\u5206\u6790：\n
                      \n
                    • \u57fa\u7840\u5c42：\u8fde\u63a5\u3001\u6d41\u91cf\u3001\u6162\u67e5\u8be2\u603b\u6570，\u5feb\u901f\u5b9a\u4f4d\u8868\u9762\u95ee\u9898\u3002<\/li>\n
                    • \u5b58\u50a8\u5f15\u64ce\u5c42：InnoDB\u7f13\u51b2\u6c60\u3001MyISAM\u952e\u7f13\u5b58，\u4f18\u5316\u5b58\u50a8\u6027\u80fd\u3002<\/li>\n
                    • \u8bed\u53e5\u5c42：\u901a\u8fc7Com_*\u3001Select_*\u5206\u6790\u67e5\u8be2\u6a21\u5f0f，\u4f18\u5316SQL\u6267\u884c\u8ba1\u5212\u3002<\/li>\n<\/ul>\n<\/li>\n
                    • \u5de5\u5177\u534f\u540c：\n
                        \n
                      • \u5b9e\u65f6\u76d1\u63a7：Innotop\u3001DMS\u7b49\u5de5\u5177\u5feb\u901f\u5b9a\u4f4d\u5b9e\u65f6\u95ee\u9898\u3002<\/li>\n
                      • \u6df1\u5ea6\u5206\u6790：Percona Toolkit\u3001pt-query-digest\u6316\u6398\u6162\u67e5\u8be2\u6839\u6e90\u3002<\/li>\n
                      • \u81ea\u52a8\u5316：Prometheus+Grafana\u5b9e\u73b0\u6307\u6807\u53ef\u89c6\u5316\u4e0e\u544a\u8b66\u81ea\u52a8\u5316\u3002<\/li>\n<\/ul>\n<\/li>\n

                        \u901a\u8fc7\u6301\u7eed\u8ddf\u8e2a\u5173\u952e\u6307\u6807\u5e76\u5f62\u6210\u4f18\u5316\u95ed\u73af，\u53ef\u5c06\u6570\u636e\u5e93\u8fd0\u7ef4\u4ece\u201c\u88ab\u52a8\u6551\u706b\u201d\u8f6c\u53d8\u4e3a\u201c\u4e3b\u52a8\u4f18\u5316\u201d，\u663e\u8457\u63d0\u5347\u7cfb\u7edf\u7684\u7a33\u5b9a\u6027\u4e0e\u6027\u80fd\u8868\u73b0\u3002<\/p>\n

                        \u516d\u3001\u5199\u4f5c\u4e0d\u6613，\u671f\u5f85\u60a8\u7684\u652f\u6301<\/h3>\n

                        \u4eb2\u7231\u7684\u8bfb\u8005，\u672c\u6587\u4ece\u6307\u6807\u539f\u7406\u5230\u5b9e\u6218\u6848\u4f8b，\u6bcf\u4e00\u4e2a\u73af\u8282\u90fd\u529b\u6c42\u8d34\u5408\u5b9e\u9645\u8fd0\u7ef4\u9700\u6c42\u3002\u5982\u679c\u672c\u6587\u5bf9\u60a8\u7406\u89e3MySQL\u72b6\u6001\u76d1\u63a7\u6709\u6240\u5e2e\u52a9，\u6073\u8bf7\u70b9\u51fb\u4e0b\u65b9\u7684\u201c\u5173\u6ce8\u201d\u6309\u94ae，\u540e\u7eed\u5c06\u6301\u7eed\u5206\u4eab\u7d22\u5f15\u4f18\u5316\u3001\u5206\u5e03\u5f0f\u4e8b\u52a1\u7b49\u6df1\u5ea6\u5185\u5bb9\u3002\u540c\u65f6，\u6b22\u8fce\u5728\u8bc4\u8bba\u533a\u7559\u8a00\u4ea4\u6d41\u60a8\u5728\u6307\u6807\u5206\u6790\u4e2d\u7684\u7ecf\u9a8c\u6216\u95ee\u9898，\u6211\u4f1a\u53ca\u65f6\u56de\u590d\u63a2\u8ba8\u3002\u5982\u679c\u89c9\u5f97\u6587\u7ae0\u5b9e\u7528，\u4e5f\u8bf7\u70b9\u8d5e\u8f6c\u53d1，\u8ba9\u66f4\u591a\u5f00\u53d1\u8005\u53d7\u76ca\u3002\u60a8\u7684\u652f\u6301\u662f\u6211\u521b\u4f5c\u7684\u6700\u5927\u52a8\u529b，\u611f\u8c22\u9605\u8bfb！<\/p>\n","protected":false},"excerpt":{"rendered":"

                        \u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb721\u6b21\uff0c\u70b9\u8d5e22\u6b21\uff0c\u6536\u85cf19\u6b21\u3002\u672c\u6587\u6df1\u5165\u89e3\u6790\u4e86MySQL\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\uff0c\u5e76\u63d0\u4f9b\u4e86\u6027\u80fd\u8c03\u4f18\u7684\u5b9e\u6218\u6848\u4f8b\u3002\u6587\u7ae0\u9996\u5148\u4ecb\u7ecd\u4e86\u8fde\u63a5\u4e0e\u7ebf\u7a0b\u7ba1\u7406\u3001\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e0e\u4e8b\u52a1\u3001\u67e5\u8be2\u4e0e\u4e34\u65f6\u8868\u3001\u5b58\u50a8\u5f15\u64ce\u7b49\u6838\u5fc3\u72b6\u6001\u6307\u6807\uff0c\u5e76\u63d0\u4f9b\u4e86\u76f8\u5e94\u7684\u67e5\u8be2\u793a\u4f8b\u548c\u8c03\u4f18\u5efa\u8bae\u3002\u63a5\u7740\uff0c\u901a\u8fc7\u4e09\u4e2a\u5b9e\u6218\u573a\u666f\uff08\u8fde\u63a5\u6570\u98d9\u5347\u3001\u4e3b\u4ece\u590d\u5236\u5ef6\u8fdf\u3001\u4e34\u65f6\u8868\u5199\u5165\u78c1\u76d8\u8fc7\u9ad8\uff09\u5c55\u793a\u4e86\u5982\u4f55\u4ece\u6307\u6807\u5f02\u5e38\u5230\u95ee\u9898\u89e3\u51b3\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u6700\u540e\uff0c\u6587\u7ae0\u4ecb\u7ecd\u4e86\u81ea\u52a8\u5316\u76d1\u63a7\u4e0e\u6307\u6807\u91c7\u96c6\u7684\u65b9\u6cd5\uff0c\u5305\u62ec\u4f7f\u7528Python\u811a\u672c\u91c7\u96c6\u5173\u952e\u6307\u6807\u4ee5\u53ca\u901a\u8fc7Prometheus\u548cGrafana\u5b9e\u73b0\u53ef\u89c6\u5316\u76d1\u63a7\u3002\u901a\u8fc7\u8fd9\u4e9b\u5185\u5bb9\uff0c\u5f00\u53d1\u8005\u53ef\u4ee5\u66f4\u597d\u5730\u638c\u63e1MySQL\u7684\u6027\u80fd\u4f18\u5316\u548c\u6545\u969c\u6392\u67e5\u6280\u5de7\uff0c\u63d0<\/p>\n","protected":false},"author":2,"featured_media":37261,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,100,43],"topic":[],"class_list":["post-37262","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mysql","tag-100","tag-43"],"yoast_head":"\nMysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/37262.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb721\u6b21\uff0c\u70b9\u8d5e22\u6b21\uff0c\u6536\u85cf19\u6b21\u3002\u672c\u6587\u6df1\u5165\u89e3\u6790\u4e86MySQL\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\uff0c\u5e76\u63d0\u4f9b\u4e86\u6027\u80fd\u8c03\u4f18\u7684\u5b9e\u6218\u6848\u4f8b\u3002\u6587\u7ae0\u9996\u5148\u4ecb\u7ecd\u4e86\u8fde\u63a5\u4e0e\u7ebf\u7a0b\u7ba1\u7406\u3001\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e0e\u4e8b\u52a1\u3001\u67e5\u8be2\u4e0e\u4e34\u65f6\u8868\u3001\u5b58\u50a8\u5f15\u64ce\u7b49\u6838\u5fc3\u72b6\u6001\u6307\u6807\uff0c\u5e76\u63d0\u4f9b\u4e86\u76f8\u5e94\u7684\u67e5\u8be2\u793a\u4f8b\u548c\u8c03\u4f18\u5efa\u8bae\u3002\u63a5\u7740\uff0c\u901a\u8fc7\u4e09\u4e2a\u5b9e\u6218\u573a\u666f\uff08\u8fde\u63a5\u6570\u98d9\u5347\u3001\u4e3b\u4ece\u590d\u5236\u5ef6\u8fdf\u3001\u4e34\u65f6\u8868\u5199\u5165\u78c1\u76d8\u8fc7\u9ad8\uff09\u5c55\u793a\u4e86\u5982\u4f55\u4ece\u6307\u6807\u5f02\u5e38\u5230\u95ee\u9898\u89e3\u51b3\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u6700\u540e\uff0c\u6587\u7ae0\u4ecb\u7ecd\u4e86\u81ea\u52a8\u5316\u76d1\u63a7\u4e0e\u6307\u6807\u91c7\u96c6\u7684\u65b9\u6cd5\uff0c\u5305\u62ec\u4f7f\u7528Python\u811a\u672c\u91c7\u96c6\u5173\u952e\u6307\u6807\u4ee5\u53ca\u901a\u8fc7Prometheus\u548cGrafana\u5b9e\u73b0\u53ef\u89c6\u5316\u76d1\u63a7\u3002\u901a\u8fc7\u8fd9\u4e9b\u5185\u5bb9\uff0c\u5f00\u53d1\u8005\u53ef\u4ee5\u66f4\u597d\u5730\u638c\u63e1MySQL\u7684\u6027\u80fd\u4f18\u5316\u548c\u6545\u969c\u6392\u67e5\u6280\u5de7\uff0c\u63d0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/37262.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-14T23:26:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250514232605-6825268d53186.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/37262.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/37262.html\",\"name\":\"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-05-14T23:26:06+00:00\",\"dateModified\":\"2025-05-14T23:26:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/37262.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/37262.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/37262.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/37262.html","og_locale":"zh_CN","og_type":"article","og_title":"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb721\u6b21\uff0c\u70b9\u8d5e22\u6b21\uff0c\u6536\u85cf19\u6b21\u3002\u672c\u6587\u6df1\u5165\u89e3\u6790\u4e86MySQL\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\uff0c\u5e76\u63d0\u4f9b\u4e86\u6027\u80fd\u8c03\u4f18\u7684\u5b9e\u6218\u6848\u4f8b\u3002\u6587\u7ae0\u9996\u5148\u4ecb\u7ecd\u4e86\u8fde\u63a5\u4e0e\u7ebf\u7a0b\u7ba1\u7406\u3001\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e0e\u4e8b\u52a1\u3001\u67e5\u8be2\u4e0e\u4e34\u65f6\u8868\u3001\u5b58\u50a8\u5f15\u64ce\u7b49\u6838\u5fc3\u72b6\u6001\u6307\u6807\uff0c\u5e76\u63d0\u4f9b\u4e86\u76f8\u5e94\u7684\u67e5\u8be2\u793a\u4f8b\u548c\u8c03\u4f18\u5efa\u8bae\u3002\u63a5\u7740\uff0c\u901a\u8fc7\u4e09\u4e2a\u5b9e\u6218\u573a\u666f\uff08\u8fde\u63a5\u6570\u98d9\u5347\u3001\u4e3b\u4ece\u590d\u5236\u5ef6\u8fdf\u3001\u4e34\u65f6\u8868\u5199\u5165\u78c1\u76d8\u8fc7\u9ad8\uff09\u5c55\u793a\u4e86\u5982\u4f55\u4ece\u6307\u6807\u5f02\u5e38\u5230\u95ee\u9898\u89e3\u51b3\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u6700\u540e\uff0c\u6587\u7ae0\u4ecb\u7ecd\u4e86\u81ea\u52a8\u5316\u76d1\u63a7\u4e0e\u6307\u6807\u91c7\u96c6\u7684\u65b9\u6cd5\uff0c\u5305\u62ec\u4f7f\u7528Python\u811a\u672c\u91c7\u96c6\u5173\u952e\u6307\u6807\u4ee5\u53ca\u901a\u8fc7Prometheus\u548cGrafana\u5b9e\u73b0\u53ef\u89c6\u5316\u76d1\u63a7\u3002\u901a\u8fc7\u8fd9\u4e9b\u5185\u5bb9\uff0c\u5f00\u53d1\u8005\u53ef\u4ee5\u66f4\u597d\u5730\u638c\u63e1MySQL\u7684\u6027\u80fd\u4f18\u5316\u548c\u6545\u969c\u6392\u67e5\u6280\u5de7\uff0c\u63d0","og_url":"https:\/\/www.wsisp.com\/helps\/37262.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-05-14T23:26:06+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250514232605-6825268d53186.jpg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/37262.html","url":"https:\/\/www.wsisp.com\/helps\/37262.html","name":"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-05-14T23:26:06+00:00","dateModified":"2025-05-14T23:26:06+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/37262.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/37262.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/37262.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Mysql\u4e4b\u670d\u52a1\u5668\u72b6\u6001\u6307\u6807\u6df1\u5ea6\u89e3\u6790\u4e0e\u6027\u80fd\u8c03\u4f18\u5b9e\u6218"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/37262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=37262"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/37262\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/37261"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=37262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=37262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=37262"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=37262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}