<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國際加速解決方案。 廣告
                ## 慢查詢日志 是一種mysql提供的日志,記錄所有執行時間超過某個時間界限的sql的語句。這個時間界限,我們可以指定。在mysql中默認沒有開啟慢查詢,即使開啟了,只會記錄執行的sql語句超過10秒的語句。 慢查詢日志文件一般放在數據庫文件data下面. #### 查看是否開啟慢查詢日志 ~~~ show variables like 'slow_query%'; ~~~ 默認是未開啟,即使是開啟了也只記錄了查詢時間超過10秒的. ~~~ +---------------------+-----------------------------------+ | Variable_name | Value | +---------------------+-----------------------------------+ | slow_query_log | OFF | //慢查詢開啟狀態 | slow_query_log_file | /var/lib/mysql/homestead-slow.log | //慢查詢日志存放位置 +---------------------+-----------------------------------+ ~~~ #### 查看設定的慢查詢時間 ~~~ show variables like 'long_query_time'; ~~~ 默認是10秒 ~~~ +-----------------+-----------+ | Variable_name | Value | +-----------------+-----------+ | long_query_time | 10.000000 | //超過10秒及進行記錄 +-----------------+-----------+ ~~~ #### 開啟慢查詢 ~~~ set global slow_query_log='ON'; ~~~ ~~~ +---------------------+-----------------------------------+ | Variable_name | Value | +---------------------+-----------------------------------+ | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/homestead-slow.log | +---------------------+-----------------------------------+ ~~~ #### 設置慢查詢日志存放的位置 ~~~ set global slow_query_log_file='/usr/local/mysql/data/slow.log'; ~~~ #### 設置慢查詢時間 ~~~ set global long_query_time=1; ~~~ #### 查看設置后的參數 ~~~ +---------------------+-----------------------------------+ | Variable_name | Value | +---------------------+-----------------------------------+ | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/homestead-slow.log | +---------------------+-----------------------------------+ ~~~ ~~~ +-----------------+----------+ | Variable_name | Value | +-----------------+----------+ | long_query_time | 4.000000 | +-----------------+----------+ ~~~ #### 測試 ~~~ select sleep(5),字段名 from 表名; ~~~ #### 查看慢查詢記錄數 ~~~ show global status like '%slow%'; ~~~ ~~~ +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | Slow_launch_threads | 0 | | Slow_queries | 3 | +---------------------+-------+ ~~~ **注意:一般情況下,一條SQL語句查詢時間較慢是因為沒有索引.加完索引后,索引文件會變大**. #### 查看文件 ~~~ # Time: 2018-03-16T08:09:44.612652Z # User@Host: homestead[homestead] @ localhost [] Id: 176 # Query_time: 5.001448 Lock_time: 0.000157 Rows_sent: 1 Rows_examined: 1 SET timestamp=1521187784; select sleep(5),name from user; ~~~ #### 通過修改文件開啟慢查詢 在my.ini文件中進行配置 ![](https://box.kancloud.cn/4a1e3335c8bd713aab61e3646afdea09_603x129.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>

                              哎呀哎呀视频在线观看