Change the maximum number of connections

IEE version: 5.1.40 1. view the current maximum number of IEE connections (default)

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

  2. Stop the database and change the maximum number of connections to 300. Regular database stop:

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

If you cannot stop the process normally, you can only force the process to be killed:

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

# Vi/etc/my-ib.cnf

# 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_passwordport            = 5029socket          = /tmp/mysql-ib.sockloose-local-infile=1# Here follows entries for some specific programs# The MySQL server[mysqld]basedir = /usr/local/infobright-4.0.6-x86_64datadir = /usr2/iee/datalog-error = /usr2/iee/data/bh.errlog-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.logmax_connections = 300port            = 5029socket          = /tmp/mysql-ib.sockskip-lockingkey_buffer = 16Mmax_allowed_packet = 500Mtable_cache = 16sort_buffer_size = 1Mread_buffer_size = 1Mread_rnd_buffer_size = 4Mmyisam_sort_buffer_size = 8Mnet_buffer_length = 8Kthread_cache_size = 32thread_stack = 512Kquery_cache_size = 8Mquery_cache_type=0# Try number of CPU cores*4 for thread_concurrencythread_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. Start the database and check that the maximum number of connections has been successfully modified to 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>

 

Change the maximum number of connections