MySQL连接数管理
作者:数据库 来源:IT科技 浏览: 【大中小】 发布时间:2025-11-05 02:33:43 评论数:
复制# 查看相关参数 mysql> show variables likemax_connections; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+ # 修改参数 (my.cnf配置文件中也要修改) mysql> setglobal max_connections = 500; Query OK,接数 0 rows affected (0.79 sec) mysql> show variables likemax_connections; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 500 | +-----------------+-------+ 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.