使用慢查詢日誌

開啟慢查詢日誌
long_query_time=0
slow_query_log=ON

檢視日誌位置slow_query_log_file 引數指定的位置。

mysql> show variables where variable_name like '%query%';
+------------------------------+----------------------------------+
| Variable_name                | Value                            |
+------------------------------+----------------------------------+
| binlog_rows_query_log_events | OFF                              |
| ft_query_expansion_limit     | 20                               |
| have_query_cache             | YES                              |
| long_query_time              | 0.000000                         |
| query_alloc_block_size       | 8192                             |
| query_cache_limit            | 1048576                          |
| query_cache_min_res_unit     | 4096                             |
| query_cache_size             | 1048576                          |
| query_cache_type             | OFF                              |
| query_cache_wlock_invalidate | OFF                              |
| query_prealloc_size          | 8192                             |
| slow_query_log               | ON                               |
| slow_query_log_file          | /app/mysql/data/DEVAPP0-slow.log |
+------------------------------+----------------------------------+

日誌說明

# Time: 131227 11:27:21       操作時間
# : root[root] @ localhost []  Id:     2   登陸使用者以及程式id show processlist顯示的會話id
# Query_time: 0.001143  Lock_time: 0.000214 Rows_sent: 1  Rows_examined: 1        基本統計資訊， 查詢時間、鎖時間、查詢記錄數、掃描記錄
use ezsela;
SET timestamp=1388114841;
select usrid from loan_app_save where usrid like 'fdl123%';