mysql常用命令学习搜集
mysql常用命令学习搜集
在mysql里直接开启慢查询:
mysql>set global slow_query_log='ON'; 开启慢日志
查询慢查询是否开启: 查询是否开启
mysql> show variables like "slow_query_log";
+----------------+-------+
| Variable_name | Value |
+----------------+-------+
| slow_query_log | ON |
+----------------+-------+
1 row in set (0.00 sec)
当然也可以用下面的命令:
mysql> show variables like "%query%"; 查看配置
+------------------------------+-------------------------+
| Variable_name | Value |
+------------------------------+-------------------------+
| binlog_rows_query_log_events | OFF |
| ft_query_expansion_limit | 20 |
| have_query_cache | YES |
| long_query_time | 0.030000 |
| 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 | /var/log/mysql/slow.log |
+------------------------------+-------------------------+
13 rows in set (0.00 sec)
设置慢日志时间
set long_query_time=5;
