[Sqlrelay-discussion] Not all connections are used
Brought to you by:
mused
|
From: Renat S. <sr...@st...> - 2009-06-02 12:58:43
|
Hello!
Today I've seen strange situation with sqlrelay-0.40.
Sqlr-scaler started 12 connections, as max as it can. But only 2 client
connections were processed in time, and other requests were queued in
forked listeners. Where were other 10 connections and what were they
doing? From the Oracle side these sessions were doing nothing.
Take a look at sqlr-status output:
--begin--
Open Server Connections: 12
Opened Server Connections: 427
Open Client Connections: 2
Opened Client Connections: 76590
Open Server Cursors: 120
Opened Server Cursors: 80739
Times New Cursor Used: 0
Times Cursor Reused: 9273202
Total Queries: 4706353
Total Errors: 16756
Forked Listeners: 9
--end--
config:
<instance id="ow_admin" port="19003"
socket="/onyma/sqlrelay/var/sqlrelay_ow_admin.socket"
addresses="0.0.0.0" dbase="oracle8" connections="1"
maxconnections="12"
maxqueuelength="0" growby="1" ttl="60"
endofsession="rollback"
sessiontimeout="600" runasuser="onyma" runasgroup="onyma"
cursors="10" authtier="listener" handoff="pass" deniedips=""
allowedips="" debug="none" maxquerysize="65536"
maxstringbindvaluelength="32767"
maxlobbindvaluelength="71680"
idleclienttimeout="120" maxlisteners="64"
listenertimeout="60"
maxsessioncount="256">
<users>
<user user="ow_admin" password="ow_admin"/>
</users>
<connections>
<connection connectionid="ow_admin"
string="user=ow_admin;password=ow_admin;oracle_sid=rdbms1;nls_lang=AMERICAN_AMERICA.UTF8;"
metric="1"/>
</connections>
</instance>
--
Renat Sabitov e-mail: sr...@st...
Stack Soft jid: sr...@ja...
|