https://www.cnblogs.com/darcy-hui/p/13212108.html#:~:text=%E4%BA%BA%E5%A4%A7%E9%87%91%E4%BB%93%E4%BF%AE%E6%94%B9%E6%9C%80%E5%A4%A7%E8%BF%9E%E6%8E%A5%E6%95%B0%20%E4%BF%AE%E6%94%B9%E6%9C%80%E5%A4%A7%E8%BF%9E%E6%8E%A5%E6%95%B0%20%E9%87%8D%E5%90%AF%20%E6%9F%A5%E8%AF%A2%E5%B7%B2%E8%BF%9E%E6%8E%A5%E6%95%B0%201%E3%80%81%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E7%94%A8%E6%88%B7%E8%BF%9E%E6%8E%A5%E6%95%B0%EF%BC%9Aselect%20connections%20%28%29%3B%202%E3%80%81%E4%BF%AE%E6%94%B9%E7%94%A8%E6%88%B7new_user%E7%9A%84%E6%9C%80%E5%A4%A7%E5%B9%B6%E5%8F%91%E8%BF%9E%E6%8E%A5%E6%95%B0%E4%B8%BA50%EF%BC%9Aalter,50%3B%203%E3%80%81%E4%BF%AE%E6%94%B9%E7%94%A8%E6%88%B7new_user%E7%9A%84%E6%9C%80%E5%A4%A7%E8%BF%9E%E6%8E%A5%E6%97%B6%E9%97%B4%E4%B8%BA2%E5%B0%8F%E6%97%B6%EF%BC%9Aalter%20user%20new_user%20with%20connection%20duration%20120%3B
修改最大连接数
重启
查询已连接数
1、查看当前用户连接数：select connections();
2、修改用户new_user的最大并发连接数为50：alter user new_user with connection limit 50;
3、修改用户new_user的最大连接时间为2小时：alter user new_user with connection duration 120;
4、修改用户new_user的最大空闲时间为2小时：alter user new_user with connect idle time 120;
重点是下面配置文件的修改，修改KingBaseES\data下的kingbase.conf的最大并发连接数：
max_connections = 50
select connections();
select * from SYS_STAT_ACTIVITY;