On Thu, Sep 14, 2017 at 10:41 PM, Omindu Rathnaweera <[email protected]>
wrote:
> 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*
>
+1
>
>
> 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 <+94%2077%20119%207211>
>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
