Hi allI have updated sequoia-2.10 to sequoia-2.10.8 and then sequoia 2.10.9We
have a test bed that consist of one controller and 2 back ends (postgresql) on
a Linux Suse 10.1 boxes.Our test has been running ok for almost 9 months with
out any problem until we updated to 2.10.9The test runs ok for at least 3 hours
with 150 tps , 640 clients, after that t.p.s goes down to 6 , really
slow.Before the update the test ran for days with the same t.p.s So what I did
was I copied all my config files from 2.10 to 2.10.9 this is my config
file<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE SEQUOIA PUBLIC
"-//Continuent//DTD SEQUOIA 2.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.dtd";><SEQUOIA>
<VirtualDatabase name="mydb"><!-- <Monitoring> <SQLMonitoring
defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select"
caseSensitive="false" applyToSkeleton ="false" monitoring="off"/>
</SQLMonitoring> </Monitoring>--> <Backup> <Backuper
backuperName="PostgresTextBackuper"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper"/>
<Backuper backuperName="PostgresBinaryBackuper"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"/>
</Backup> <AuthenticationManager> <Admin> <User
username="admin" password="mypass"/> </Admin> <VirtualUsers>
<VirtualLogin vLogin="postgres" vPassword="mypassword"/> </VirtualUsers>
</AuthenticationManager> <DatabaseBackend name="mydb1"
driver="org.postgresql.Driver" url="jdbc:postgresql://testdb1:5432/mydb1"
connectionTestStatement="select 1"> <DatabaseSchema
dynamicPrecision="table"> <StoredProcedureSemantic
procedureName="liabilitycheckone" parameterCount="6" writeTables=""
proceduresReferenced="" hasSelect="true" hasInsert="false" hasUpdate="false"
hasDelete="false" hasDDL="false" hasTransaction="false"
isCausallyDependent="false" isCommutative="true" />
<StoredProcedureSemantic procedureName="liabilitypassall" parameterCount="1"
writeTables="keytotal" proceduresReferenced="" hasSelect="true"
hasInsert="true" hasUpdate="true" hasDelete="false" hasDDL="false"
hasTransaction="false" isCausallyDependent="false" isCommutative="false" />
</DatabaseSchema> <ConnectionManager vLogin="postgres" rLogin="postgres"
rPassword=""> <VariablePoolConnectionManager initPoolSize="800"
minPoolSize="640" maxPoolSize="0" idleTimeout="180" waitTimeout="0"/>
</ConnectionManager> </DatabaseBackend> <DatabaseBackend name="mydb2"
driver="org.postgresql.Driver" url="jdbc:postgresql://testdb2:5432/mydb1"
connectionTestStatement="select 1"> <DatabaseSchema
dynamicPrecision="table"> <StoredProcedureSemantic
procedureName="liabilitycheckone" parameterCount="6" writeTables=""
proceduresReferenced="" hasSelect="true" hasInsert="false" hasUpdate="false"
hasDelete="false" hasDDL="false" hasTransaction="false"
isCausallyDependent="false" isCommutative="true" />
<StoredProcedureSemantic procedureName="liabilitypassall" parameterCount="1"
writeTables="keytotal" proceduresReferenced="" hasSelect="true"
hasInsert="true" hasUpdate="true" hasDelete="false" hasDDL="false"
hasTransaction="false" isCausallyDependent="false" isCommutative="false" />
</DatabaseSchema> <ConnectionManager vLogin="postgres" rLogin="postgres"
rPassword=""> <VariablePoolConnectionManager initPoolSize="800"
minPoolSize="640" maxPoolSize="0" idleTimeout="180" waitTimeout="0"/>
</ConnectionManager> </DatabaseBackend><RequestManager>
<RequestScheduler> <RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler> <RequestCache> <MetadataCache/>
<ParsingCache/> <ResultCache granularity="table"/> </RequestCache>
<LoadBalancer> <RAIDb-1> <WaitForCompletion
policy="all"/> <RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1> </LoadBalancer> </RequestManager>
</VirtualDatabase></SEQUOIA>Wondering if between 2.10 and 2.10.9 we need to
change somethingThanks in advance for any help.JulioC._______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
