<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ## 一、概述 cpu利用率過高,會影響運行; ## 二、可能原因 ### **1、SQL語句查詢太慢,導致CPU利用率太高;** ``` show processlist ``` 找到SQL語句。這里的語句都值得去分析一下; 通過EXPLAIN分析SQL語句; 優化之,如加索引等; ### **2、如果CPU負載持續很高,但內存和IO都還好的話,有可能是索引的問題;** 舉例: ``` SELECT SUM(vcardpoole0_.show_used_flow) AS col_0_0_ FROM v_card_pooled_quota vcardpoole0_ WHERE vcardpoole0_.card_id=25877 AND vcardpoole0_.revise_valid_time>='2022-01-12 00:15:15' AND vcardpoole0_.revise_invalid_time<='2022-08-12 00:15:15' ``` 發現該語句大規模執行的時候,導致CPU利用率飆升; 分析: ``` explain SELECT SUM(vcardpoole0_.show_used_flow) AS col_0_0_ FROM v_card_pooled_quota vcardpoole0_ WHERE vcardpoole0_.card_id=25877 AND vcardpoole0_.revise_valid_time>='2022-01-12 00:15:15' AND vcardpoole0_.revise_invalid_time<='2022-08-12 00:15:15' ``` ![](https://img.kancloud.cn/aa/8b/aa8b6577bf8cf61680586a31f4dbf55d_1032x161.png) 重新按照實際,建立合適的索引后,問題解決;
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看