mysql变量修改及生效
mysql> show global variables like "%_time";+------------------------+----------+
| Variable_name | Value |
+------------------------+----------+
| flush_time | 0 |
| innodb_old_blocks_time | 0 |
| long_query_time | 1.000000 |
| slow_launch_time | 2 |
+------------------------+----------+
4 rows in set (0.00 sec)
mysql> set global long_query_time=2;
Query OK, 0 rows affected (0.00 sec)
页:
[1]