Mysql慢查询slow query log

Mysql慢查询slow_query_log

一般要打开slow query log 才能show processlist 到比较多的东西

方法1 手工临时打开

mysql> show variables like ‘%slow%’;
+———————+—————————————–+
| Variable_name | Value |
+———————+—————————————–+
| log_slow_queries | OFF |
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | /data/mysql/var/frgdb_funshion-slow.log |
+———————+—————————————–+

mysql> set global slow_query_log=’ON’;

mysql> show variables like ‘%slow%’;
+———————+—————————————–+
| Variable_name | Value |
+———————+—————————————–+
| log_slow_queries | ON |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /data/mysql/var/frgdb_funshion-slow.log |
+———————+—————————————–+
4 rows in set (0.00 sec)

mysql> show variables like ‘long%’;
+—————–+———-+
| Variable_name | Value |
+—————–+———-+
| long_query_time | 1.000000 |
+—————–+———-+
1 row in set (0.00 sec)

mysql> show variables like ‘%que%’;
+——————————-+—————————————–+
| Variable_name | Value |
+——————————-+—————————————–+
| delayed_queue_size | 1000 |
| ft_query_expansion_limit | 20 |
| have_query_cache | YES |
| log_queries_not_using_indexes | OFF |
| log_slow_queries | ON |
| long_query_time | 1.000000 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| slow_query_log | ON |
| slow_query_log_file | /data/mysql/var/frgdb_funshion-slow.log |
| unique_checks | ON |
+——————————-+—————————————–+

##用过了
vi /etc/my.cnf
long_query_time = 0.1
slow_query_log=1
log_slow_queries = /data/log/slow-mysql.log
log_output = FILE

slow_query_log=1
slow_query_log_file = /var/log/mysql/mysql-slow.log
log_output = FILE or log-output = FILE
long_query_time = 2

log-queries-not-using-indexes