IEE版本：5.1.40
1.查看当前IEE最大连接数(缺省值)
代码语言：javascript复制mysql> show variables like 'max_connections';
----------------- -------
| Variable_name | Value |
----------------- -------
| max_connections | 151 |
----------------- -------
1 row in set (0.00 sec)2.停库，修改最大连接数为300
常规停库：
代码语言：javascript复制#/etc/init.d/mysql-ib stop常规停不了的话就只能强制杀进程：
代码语言：javascript复制# ps -ef|grep mysql|grep -v grep|awk '{print $2}'|xargs kill -9 # vi /etc/my-ib.cnf 加入配置max_connections = 300
代码语言：javascript复制# Example Infobright config file (mysql server).
# In this file, you can use all long options that mysql supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 5029
socket = /tmp/mysql-ib.sock
loose-local-infile=1
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
basedir = /usr/local/infobright-4.0.6-x86_64
datadir = /usr2/iee/data
log-error = /usr2/iee/data/bh.err
log-output = FILE
#general_log=1
#general_log_file=path-of-datadir/general_query.log
#slow_query_log=1
#slow_query_log_file=path-of-datadir/slow_query.log
max_connections = 300
port = 5029
socket = /tmp/mysql-ib.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 500M
table_cache = 16
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 8M
net_buffer_length = 8K
thread_cache_size = 32
thread_stack = 512K
query_cache_size = 8M
query_cache_type=0
# Try number of CPU cores*4 for thread_concurrency
thread_concurrency = 8
#core-file
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
"/etc/my-ib.cnf" 90L, 2112C written 3.启动数据库，查看最大连接数已成功修改为300
代码语言：javascript复制#/etc/init.d/mysql-ib startmysql> show variables like 'max_connections';
----------------- -------
| Variable_name | Value |
----------------- -------
| max_connections | 300 |
----------------- -------
1 row in set (0.00 sec)
mysql>
