MySQL 8 新特性：全局参数持久化！
作者:域名 来源:人工智能 浏览: 【大中小】 发布时间:2025-11-04 19:27:38 评论数:
复制mysql> select * from performance_schema.persisted_variables; Empty set (0.00 sec) mysql> show variables like%max_connections%; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | max_connections | 151 | | mysqlx_max_connections | 100 | +------------------------+-------+ 2 rowsinset (0.00 sec) mysql> set persist max_connections=300; Query OK,特性 0 rows affected (0.00 sec) mysql> select * from performance_schema.persisted_variables; +-----------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------+----------------+ | max_connections | 300 | +-----------------+----------------+ 1 row inset (0.00 sec) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.