And one more thing, shall we also change the default values for maxIdle and
maxActive to avoid getting the following WARN ?
*WARN {org.apache.tomcat.jdbc.pool.ConnectionPool} - maxIdle is larger
than maxActive, setting maxIdle to: 40*
On Thu, Sep 14, 2017 at 10:33 PM, Omindu Rathnaweera <[email protected]>
wrote:
> Following are the pooling properties we support for JDBC user stores ATM
> as per [1].
>
> maxActive
> minIdle
> maxIdle
> maxWait
> testWhileIdle
> timeBetweenEvictionRunsMillis
> minEvictableIdleTimeMillis
> validationQuery
>
> +1 for adding the rest of the properties. We can use [2] as a reference
> for the rest of the properties. Having these will be valuable when tuning
> and troubleshooting the secondary JDBC user stores.
>
> [1] - https://github.com/wso2/carbon-kernel/blob/v4.4.17/
> core/org.wso2.carbon.user.core/src/main/java/org/wso2/
> carbon/user/core/util/DatabaseUtil.java#L89
>
> [2] - https://github.com/wso2/carbon-kernel/blob/v4.4.17/
> core/org.wso2.carbon.ndatasource.rdbms/src/main/java/org/wso2/carbon/
> ndatasource/rdbms/utils/RDBMSDataSourceUtils.java#L179
>
> Regards,
> Omindu.
>
> On Tue, Sep 12, 2017 at 10:54 PM, Darshana Gunawardana <[email protected]>
> wrote:
>
>> [looping dev]
>>
>> On Tue, Sep 12, 2017 at 10:51 PM, Darshana Gunawardana <[email protected]
>> > wrote:
>>
>>> Hi Harsha,
>>>
>>> Using datasources for secondary userstores not works in the tenant.
>>>
>>> * In order to load the realm its need datasources be loaded
>>> * In order to load datasources its need realm be loaded
>>>
>>> So we have to go forward with reading needed db tuning parameters as
>>> properties of the userstore config.
>>>
>>> Thanks,
>>>
>>> On Tue, Sep 12, 2017 at 10:38 PM, Harsha Thirimanna <[email protected]>
>>> wrote:
>>>
>>>> Hi All,
>>>>
>>>> Currently we are not supporting $subject and don't we need to address
>>>> this because we can't tune up the database config within secondary user
>>>> store config now.
>>>> At least we have to improve that part in secondary user stores now. But
>>>> it is not the right solution.
>>>>
>>>> WDYT ?
>>>>
>>>> https://wso2.org/jira/browse/IDENTITY-6419
>>>>
>>>>
>>>> *Harsha Thirimanna*
>>>> *Associate Tech Lead | WSO2*
>>>>
>>>> Email: [email protected]
>>>> Mob: +94715186770 <+94%2071%20518%206770>
>>>> Blog: http://harshathirimanna.blogspot.com/
>>>> Twitter: http://twitter.com/harshathirimann
>>>> Linked-In: linked-in: http://www.linkedin.com/pub/ha
>>>> rsha-thirimanna/10/ab8/122
>>>> <http://wso2.com/signature>
>>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>>
>>> *Darshana Gunawardana*Technical Lead
>>> WSO2 Inc.; http://wso2.com
>>>
>>> *E-mail: [email protected] <[email protected]>*
>>> *Mobile: +94718566859 <+94%2071%20856%206859>*Lean . Enterprise .
>>> Middleware
>>>
>>
>>
>>
>> --
>> Regards,
>>
>>
>> *Darshana Gunawardana*Technical Lead
>> WSO2 Inc.; http://wso2.com
>>
>> *E-mail: [email protected] <[email protected]>*
>> *Mobile: +94718566859 <+94%2071%20856%206859>*Lean . Enterprise .
>> Middleware
>>
>
>
>
> --
> Omindu Rathnaweera
> Senior Software Engineer, WSO2 Inc.
> Mobile: +94 771 197 211 <+94%2077%20119%207211>
>
--
Omindu Rathnaweera
Senior Software Engineer, WSO2 Inc.
Mobile: +94 771 197 211
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
