2.1.15 慢日志相关命令
慢日志相关的命令:
2.1.15.1 查询慢查询日志的开启状态
mysql> show @@slow_query_log;
+------------------+
| @@slow_query_log |
+------------------+
| 0 |
+------------------+
1 row in set (0.00 sec)
2.1.15.2 开启慢查询日志
mysql> enable @@slow_query_log;
Query OK, 1 row affected (0.09 sec)
enable slow_query_log success
2.1.15.3 关闭慢查询日志
mysql> disable @@slow_query_log;
Query OK, 1 row affected (0.03 sec)
disable slow_query_log success
2.1.15.4 查看慢查询日志统计阈值
mysql> show @@slow_query.time;
+-------------------+
| @@slow_query.time |
+-------------------+
| 100 |
+-------------------+
1 row in set (0.00 sec)
2.1.15.5 修改慢查询日志统计阈值
mysql> reload @@slow_query.time=200;
Query OK, 1 row affected (0.10 sec)
reload @@slow_query.time success
mysql> show @@slow_query.time;
+-------------------+
| @@slow_query.time |
+-------------------+
| 200 |
+-------------------+
1 row in set (0.00 sec)
2.1.15.6 查看慢查询日志刷盘周期
mysql> show @@slow_query.flushperiod;
+--------------------------+
| @@slow_query.flushperiod |
+--------------------------+
| 1 |
+--------------------------+
1 row in set (0.00 sec)
2.1.15.7 修改慢查询日志刷盘周期
mysql> reload @@slow_query.flushperiod=2;
Query OK, 1 row affected (0.05 sec)
reload @@slow_query.flushPeriod success
mysql> show @@slow_query.flushperiod;
+--------------------------+
| @@slow_query.flushperiod |
+--------------------------+
| 2 |
+--------------------------+
1 row in set (0.00 sec)
2.1.15.8 查看慢查询日志刷盘条数阈值
mysql> show @@slow_query.flushsize;
+------------------------+
| @@slow_query.flushsize |
+------------------------+
| 1000 |
+------------------------+
1 row in set (0.01 sec)
2.1.15.9 修改慢查询日志刷盘条数阈值
mysql> reload @@slow_query.flushsize=1100;
Query OK, 1 row affected (0.03 sec)
reload @@slow_query.flushSize success
mysql> show @@slow_query.flushsize;
+------------------------+
| @@slow_query.flushsize |
+------------------------+
| 1100 |
+------------------------+
1 row in set (0.00 sec)