关关采集出现200|error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool

200|error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.    200 |连接错误：超时。从池中获取连接之前经过的超时时间。这可能是因为所有池连接都在使用中，并且已达到最大池大小。

Data Source=localhost;Database=jieqi;User ID=root;Password=root;port=3306;charset=utf8;

Data Source=localhost;Database=jieqi;User ID=root;Password=root;port=3306;charset=utf8;pooling=true;min pool size=5;max pool size=1024;connect timeout = 20;

关关采集器出现错误:

200|error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.    200 |连接错误：超时。从池中获取连接之前经过的超时时间。这可能是因为所有池连接都在使用中，并且已达到最大池大小。

解决办法:

关关采集器 – 系统设置 – 数据库连接参数默认大概是这个样子的:

Data Source=localhost;Database=jieqi;User ID=root;Password=root;port=3306;charset=utf8;

添加几个参数pooling=true;min pool size=5;max pool size=1024;connect timeout = 20;,完成后大概是这个样子的:

Data Source=localhost;Database=jieqi;User ID=root;Password=root;port=3306;charset=utf8;pooling=true;min pool size=5;max pool size=1024;connect timeout = 20;

其中的 max pool size 尤其重要,如还有报错, 可继续加大.