mysql 中文参数设置_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

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