Transport
Option | Default value | Description |
---|---|---|
|
| Maximum number of threads dedicated to the initial request processing. Zero indicates to use the system default of max available processors. All access to the Data Virtuality Server (JDBC and ODBC) is controlled by the |
Changing the Settings
デフォルト設定を変更するには、%dvDir%/standalone/configuration/dvserver-standalone.xmlファイル、つまり XML タグ<subsystem:xmlns="urn:jboss:domain:teiid:1.1">で記述されているセクションを変更します。通常、これらの設定項目はありません:
<
subsystem
xmlns
=
"urn:jboss:domain:teiid:1.1"
>
...
<
transport
name
=
"jdbc"
socket-binding
=
"dv-jdbc"
>
...
</
transport
>
<
transport
name
=
"jdbc-ssl"
socket-binding
=
"dv-jdbc-ssl"
>
...
</
transport
>
<
transport
name
=
"odbc"
socket-binding
=
"dv-odbc"
protocol
=
"pg"
>
...
</
transport
>
<
transport
name
=
"odbc-ssl"
socket-binding
=
"dv-odbc-ssl"
protocol
=
"pg"
>
...
</
transport
>
...
</
subsystem
>
変更する設定を、希望するトランスポートタイプにプロパティとして追加することができます。以下はその例です:
<
subsystem
xmlns
=
"urn:jboss:domain:teiid:1.1"
>
...
<
transport
name
=
"jdbc"
socket-binding
=
"dv-jdbc"
max-socket-threads
=
"4"
>
...
</
transport
>
<
transport
name
=
"jdbc-ssl"
socket-binding
=
"dv-jdbc-ssl"
max-socket-threads
=
"4"
>
...
</
transport
>
<
transport
name
=
"odbc"
socket-binding
=
"dv-odbc"
protocol
=
"pg"
max-socket-threads
=
"4"
>
...
</
transport
>
<
transport
name
=
"odbc-ssl"
socket-binding
=
"dv-odbc-ssl"
protocol
=
"pg"
max-socket-threads
=
"4"
>
...
</
transport
>
...
</
subsystem
>
Query Engine
Option | Default value | Description |
---|---|---|
|
| The query engine has several settings determining its thread utilization. The |
|
| Should always be smaller than |
|
| Should always be smaller than max-threads. By default, |
|
| Provides course scheduling of long-running processor plans. Plans whose execution exceeds the indicated time slice will be re-queued for additional processing to allow for other plans to be initiated. The time slice is from the perspective of the engine processing thread. This value is not honoured exactly as the plan may not be at a re-startable point when the time slice expires. This is not a replacement for the thread scheduling performed by Java and the operating system, instead, it just ensures that the Data Virtuality Server allows other work to be started if the current set of active plans includes long-running queries |
Changing the Settings
デフォルト設定を変更するには、%dvDir%/standalone/configuration/dvserver-standalone.xmlファイル、つまり XML タグ<subsystem:xmlns="urn:jboss:domain:teiid:1.1">で記述されているセクションを変更します。通常、これらの設定項目はありません:
<
subsystem
xmlns
=
"urn:jboss:domain:teiid:1.1"
>
<
buffer
-service
memory-buffer-off-heap
=
"true"
max-storage-object-size
=
"134217728"
/>
...
</
subsystem
>
buffer-service
タグの後に、変更する 設定を追加できます。以下はその例です:
<
subsystem
xmlns
=
"urn:jboss:domain:teiid:1.1"
>
<
async
-thread-pool>teiid-async</
async
-thread-pool>
<
buffer
-service
memory-buffer-off-heap
=
"true"
max-storage-object-size
=
"134217728"
/>
<
max
-threads>128</
max
-threads>
<
max
-active-plans>40</
max
-active-plans>
<
thread
-count-for-source-concurrency>4</
thread
-count-for-source-concurrency>
<
time
-slice-in-millseconds>4000</
time
-slice-in-millseconds>
...
</
subsystem
>
Threads for Job Execution
Option | Default value | Description |
---|---|---|
|
| Number of threads available for concurrent execution of jobs. If you increase this setting, remember to adjust |
このオプションの Default Option 値を変更するには、%dvDir%/standalone/configuration/dvserver-standalone.xmlファイルに移動し、次の行を編集します:
<
server
xmlns
=
"urn:jboss:domain:12.0"
>
[..]
<
profile
>
[..]
<
subsystem
xmlns
=
"urn:jboss:domain:teiid:1.1"
>
[..]
<
quartz
>
<
property
name
=
"org.quartz.threadPool.threadCount"
value
=
"15"
/>
<
property
name
=
"org.quartz.jobStore.class"
value
=
"com.datavirtuality.dv.core.scheduler.DVJobStore"
/>
<
property
name
=
"com.datavirtuality.quartz.DVJobStore.misfireThreshold"
value
=
"3600000"
/>
</
quartz
>