Transport

Option

Default value

Description

max-socket-threads

0

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 transport element in the configuration. Socket threads are configured for each transport. They handle NIO non-blocking IO operations and directly service any operation that can run without blocking. For longer-running operations, the socket threads queue with work the query engine

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

max-threads

64

The query engine has several settings determining its thread utilization. The max-threads option sets the total number of threads available in the process pool for query engine work (processing plans, transaction control operations, processing source queries, etc.). Consider increasing the maximum threads on systems with a large number of available processors and/or when It is common to issue non-transactional queries that result in a large number of concurrent source requests

max-active-plans

20

Should always be smaller than max-threads. Use the formula (max-threads / max_active_plans) * 2 to calculate the number of max-threads available to be used for processing each user query. Increasing max-active-plans should be considered for workloads with a high number of long-running queries and/or systems with many available processors. If memory issues arise from increasing max-threads and max-active-plans, consider decreasing processor-batch-size to limit the base number of memory rows consumed by each plan

thread-count-for-source-concurrency

0

Should always be smaller than max-threads. By default, thread-count-for-source-concurrency is calculated by (max-threads / max_active_plans) * 2 to determine the threads available for processing concurrent source requests for each user query

time-slice-in-milliseconds

2000

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

threadCount

15

Number of threads available for concurrent execution of jobs. If you increase this setting, remember to adjust max-threads and max-active-plans as well

このオプションの 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>