Hi all,
While doing testing on a Sequoia 2.10 environment with one controller
and three PostgreSQL nodes, I'm having very slow performance on {call
... } style stored procedure invocations. Using just one stored
procedure that do select (*) from table and save the row-counts on
another table, PreparedStatement.execute() execution time starts with
141ms and ends with > 20s when called repeatedly.
What can be the cause of this behaviour?
I've attached my virtualdatabase configuration
Thanks in advance,
Saulo G.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.6//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.6.dtd";>
<SEQUOIA>
<VirtualDatabase name="vdb" maxNbOfConnections="1000">
<!--
<Distribution>
<MessageTimeouts/>
</Distribution>
-->
<Backup>
<Backuper backuperName="Octopus" className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper" options="zip=true"/>
<Backuper backuperName="postgres" className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"
options="dumpServer=host-01,splitSize=500m"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="node1" driver="org.postgresql.Driver" url="jdbc:postgresql://host-01/db" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="node2" driver="org.postgresql.Driver" url="jdbc:postgresql://host-02/db" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="node3" driver="org.postgresql.Driver" url="jdbc:postgresql://host-03/db" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache />
<ParsingCache />
<ResultCache granularity="table" pendingTimeout="2">
<DefaultResultCacheRule timestampResolution="1000" >
<EagerCaching />
</DefaultResultCacheRule>
</ResultCache>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://host-01/log" login="postgres" password="">
<RecoveryLogTable tableName="recovery" logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="checkpoint"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<BackendTable tableName="backend"
databaseNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<DumpTable tableName="dump" dumpNameColumnType="VARCHAR NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR NOT NULL"
dumpFormatColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
