mysql并发连接量设置

vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
max_connections=1000    #在此设置最大连接数 默认是没有这一行的 直接添加即可
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

services mysqld restart
mysqladmin -uroot -ppasswd variables | grep max_connections
| max_connections                         | 1000   

 

2014年1月3日, PM 01:16:42