I've fixed this issue using the attached config file.
Regards,
Saulo G.
Saulo Gil wrote:
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.
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
<?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">
<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.PostgreSQLPlainTextBackuper" options="dumpServer=192.168.6.220,splitSize=500m,pgDumpFlags=-i"/>
</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://192.168.6.220/db" connectionTestStatement="select 1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="true">
<DefaultStoredProcedureSemantic
hasSelect="true"
hasInsert="true"
hasUpdate="true"
hasDelete="true"
hasDDL="false"
hasTransaction="false"
isCausallyDependent="true"
isCommutative="false"
/>
<StoredProcedureSemantic procedureName="sequoia_rowcounts"
parameterCount="1"
writeTables="true"
hasSelect="true"
hasInsert="true"
hasUpdate="false"
hasDelete="false"
hasDDL="false"
hasTransaction="false"
isCausallyDependent="true"
isCommutative="false" />
</DatabaseSchema>
<ConnectionManager vLogin="user" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="node2" driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.6.221/db" connectionTestStatement="select 1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="true">
<DefaultStoredProcedureSemantic
hasSelect="true"
hasInsert="true"
hasUpdate="true"
hasDelete="true"
hasDDL="false"
hasTransaction="false"
isCausallyDependent="true"
isCommutative="false"
/>
<StoredProcedureSemantic procedureName="sequoia_rowcounts"
parameterCount="1"
writeTables="true"
hasSelect="true"
hasInsert="true"
hasUpdate="false"
hasDelete="false"
hasDDL="false"
hasTransaction="false"
isCausallyDependent="true"
isCommutative="false" />
</DatabaseSchema>
<ConnectionManager vLogin="user" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="node3" driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.6.222/db" connectionTestStatement="select 1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="true">
<DefaultStoredProcedureSemantic
hasSelect="true"
hasInsert="true"
hasUpdate="true"
hasDelete="true"
hasDDL="false"
hasTransaction="false"
isCausallyDependent="true"
isCommutative="false"
/>
<StoredProcedureSemantic procedureName="sequoia_rowcounts"
parameterCount="1"
writeTables="true"
hasSelect="true"
hasInsert="true"
hasUpdate="false"
hasDelete="false"
hasDDL="false"
hasTransaction="false"
isCausallyDependent="true"
isCommutative="false" />
</DatabaseSchema>
<ConnectionManager vLogin="user" rLogin="postgres" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache />
<ParsingCache />
<ResultCache granularity="database" pendingTimeout="2">
<DefaultResultCacheRule timestampResolution="1000" >
<!-- <EagerCaching /> -->
<EagerCaching />
</DefaultResultCacheRule>
</ResultCache>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.6.220/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
