首页 > 代码库 > IEE修改最大连接数
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
# 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.启动数据库，查看最大连接数已成功修改为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>
IEE修改最大连接数
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。