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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
