<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
We are using MongoClient, which has it's own connection pooling
mechanism. The default size of connection pool is 100 connections.<br>
<br>
When MongoClient needs to do some DB operation, it opens new
connection and put it to connection pool until there are 100
connections here. Once there are 100 connections, it stops open
new connections, but it will start to reuse existing ones instead.<br>
<br>
As of now, we don't support configuration of connection pool in
Keycloak, but I've added
<a class="moz-txt-link-freetext" href="https://issues.jboss.org/browse/KEYCLOAK-799">https://issues.jboss.org/browse/KEYCLOAK-799</a>, which will be
available in next 1.1.0.Beta1 version. Then you will be able to
add this to mongo configuration in keycloak-server.json:<br>
<br>
"connectionsPerHost": 10<br>
<br>
to limit size of connection pool to 10 connections for example.
You will be also able to configure other options related to
connections and connection pooling.<br>
<br>
Marek<br>
<br>
On 30.10.2014 02:59, prab rrrr wrote:<br>
</div>
<blockquote
cite="mid:1828554299.738311.1414634375725.JavaMail.yahoo@jws10002g.mail.ne1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif;font-size:16px">
<div id="yui_3_16_0_1_1414634031536_8317" dir="ltr">I configured
Keycloak 1.0.3 to use Mongodb and created a new realm, added a
user and deleted the user. While doing so I noticed that
Keycloak opens 1 connection each for almost any
update/insert/delete and it doesn't close them. 24 Connections
were opened for 1 user performing those operations and they
remained open even after 3 hrs of inactivity.</div>
<div id="yui_3_16_0_1_1414634031536_8317" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1414634031536_8317" dir="ltr">Can a fix be
put in for this issue?</div>
<div id="yui_3_16_0_1_1414634031536_8317" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1414634031536_8317" dir="ltr"><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
keycloak-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br>
</body>
</html>