IEE修改最大连接数

IEE版本:5.1.40

1.查看当前IEE最大连接数(缺省值)

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.00 sec)

2.停库,修改最大连接数为300

常规停库:

#/etc/init.d/mysql-ib stop

常规停不了的话就只能强制杀进程:

# ps -ef|grep mysql|grep -v grep|awk '{print $2}'|xargs kill -9

vi /etc/my-ib.cnf 加入配置max_connections = 300

# 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

启动数据库:

#/etc/init.d/mysql-ib start

查看最大连接数:

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 300   |
+-----------------+-------+
1 row in set (0.00 sec)
mysql>

如果想查看当前连接进程列表,可用下面的命令:

show processlist;
This entry was posted in Infobright and tagged , . Bookmark the permalink.