timesten修改连接数connections

环境:

OS:Centos 7

DB:18.1.14

 

1.查看当前的连接数
Command> call ttconfiguration('connections');
< Connections, 95 >
1 row found.

 

2.修改配置文件
vi sys.odbc.ini

connections=200

 

3.重启动ttDaemonAdmin
[instanceadmin@localhost conf]$ttDaemonAdmin -stop
[instanceadmin@localhost conf]$ttDaemonAdmin -start

查看
[instanceadmin@localhost ~]$ ttisql sampledb
Command> call ttconfiguration('connections');
< Connections, 95 >
1 row found.

发现不生效,下面重新加载
[instanceadmin@localhost ~]$ ttadmin -rampolicy manual sampledb
[instanceadmin@localhost ~]$ ttadmin -ramunload sampledb
[instanceadmin@localhost ~]$ ttadmin -ramload sampledb
[instanceadmin@localhost ~]$ ttadmin -rampolicy always sampledb

继续查看
Command> call ttconfiguration('connections');
< Connections, 200 >
1 row found.

看到已经生效

说明:
最开始直接修改参数重启,发现一直无法启动
TT14000: TimesTen daemon internal error: Could not send 'manage' request to subdaemon
后面修改kernel.sem就可以了.

Modify /etc/sysctl.conf to that value, so that after a reboot it uses this value again:
kernel.sem = 655 32000 100 128

 

特别说明:

连接数的设置与内核参数kernel.sem设置有关,若设置不合适,加载到内存的时候会,会报如下的错误:
TT14000: TimesTen daemon internal error: Error 22 creating semaphores [key = 0x0b00c940, nsems = 10155]
kernel.sem中第一个值需要大于报错信息中nsems = 10155的值.

kernel.sem = 8192 524288 200 256
第一个值8192支持的连接数:5000

kernel.sem = 16384 524288 200 256
第一个值16384支持的连接数:10000