MySQL 8.0 一些参数设置

----------------------------------------------------------------------------------------------------------------

1

#开启慢查询日志
#MySQL8.0 默认关闭
slow_query_log=on

重启mysql服务
service mysql restart

show variables like '%slow%';
+---------------------------+------------------------------------+
| Variable_name             | Value                              |
+---------------------------+------------------------------------+
| log_slow_admin_statements | OFF                                |
| log_slow_slave_statements | OFF                                |
| slow_launch_time          | 2                                  |
| slow_query_log            | ON                                 |
| slow_query_log_file       | /var/lib/mysql/LoSingSang-slow.log |
+---------------------------+------------------------------------+
5 rows in set (0.02 sec)

pt-query-digest --since=24h /var/lib/mysql/LoSingSang-slow.log > query.log

----------------------------------------------------------------------------------------------------------------