com.hazelcast.config

Class SqlConfig

java.lang.Object

com.hazelcast.config.SqlConfig

public class SqlConfig
extends Object

SQL service configuration.

Field Summary

Fields

Modifier and Type	Field and Description
static int	DEFAULT_EXECUTOR_POOL_SIZE Default number of threads responsible for execution of SQL statements.
static int	DEFAULT_OPERATION_POOL_SIZE Default number of threads responsible for network operations processing.
static int	DEFAULT_STATEMENT_TIMEOUT_MILLIS Default timeout in milliseconds that is applied to statements without explicit timeout.

Constructor Summary

Constructors

Constructor and Description
SqlConfig()

Method Summary

Modifier and Type	Method and Description
int	getExecutorPoolSize() Gets the number of threads responsible for execution of SQL statements.
int	getOperationPoolSize() Gets the number of threads responsible for network operations processing.
long	getStatementTimeoutMillis() Gets the timeout in milliseconds that is applied to statements without an explicit timeout.
SqlConfig	setExecutorPoolSize(int executorPoolSize) Sets the number of threads responsible for execution of SQL statements.
SqlConfig	setOperationPoolSize(int operationPoolSize) Sets the number of threads responsible for network operations processing.
SqlConfig	setStatementTimeoutMillis(long statementTimeoutMillis) Sets the timeout in milliseconds that is applied to statements without an explicit timeout.
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

DEFAULT_EXECUTOR_POOL_SIZE

public static final int DEFAULT_EXECUTOR_POOL_SIZE

Default number of threads responsible for execution of SQL statements.

See Also:

Constant Field Values

DEFAULT_OPERATION_POOL_SIZE

public static final int DEFAULT_OPERATION_POOL_SIZE

Default number of threads responsible for network operations processing.

See Also:

Constant Field Values

DEFAULT_STATEMENT_TIMEOUT_MILLIS

public static final int DEFAULT_STATEMENT_TIMEOUT_MILLIS

Default timeout in milliseconds that is applied to statements without explicit timeout.

See Also:

Constant Field Values

Constructor Detail

SqlConfig

public SqlConfig()

Method Detail

getExecutorPoolSize

public int getExecutorPoolSize()

Gets the number of threads responsible for execution of SQL statements.

Returns:

number of threads responsible for execution of SQL statements

setExecutorPoolSize

public SqlConfig setExecutorPoolSize(int executorPoolSize)

Sets the number of threads responsible for execution of SQL statements.

The default value -1 sets the pool size equal to the number of CPU cores, and should be good enough for the most workloads.

Setting the value to less than the number of CPU cores will limit the degree of parallelism of the SQL subsystem. This may be beneficial if you would like to prioritize other CPU-intensive workloads on the same machine.

It is not recommended to set the value of this parameter greater than the number of CPU cores because it may decrease the system's overall performance due to excessive context switches.

Defaults to -1.

Parameters:

executorPoolSize - number of threads responsible for execution of SQL statements

Returns:

this instance for chaining

getOperationPoolSize

public int getOperationPoolSize()

Gets the number of threads responsible for network operations processing.

Returns:

number of threads responsible for network operations processing

setOperationPoolSize

public SqlConfig setOperationPoolSize(int operationPoolSize)

Sets the number of threads responsible for network operations processing.

When Hazelcast members execute an SQL statement, they send commands to each other over the network to coordinate the execution. This includes requests to start or stop execution, or a request to process a batch of data. These commands are processed in a separate operation thread pool, to avoid frequent interruption of running SQL fragments.

The default value -1 sets the pool size equal to the number of CPU cores, and should be good enough for the most workloads.

Setting the value to less than the number of CPU cores may improve the overall performance on machines with large CPU count, because it will decrease the number of context switches.

It is not recommended to set the value of this parameter greater than the number of CPU cores because it may decrease the system's overall performance due to excessive context switches.

Defaults to -1.

Parameters:

operationPoolSize - number of threads responsible for network operations processing

Returns:

this instance for chaining

getStatementTimeoutMillis

public long getStatementTimeoutMillis()

Gets the timeout in milliseconds that is applied to statements without an explicit timeout.

Returns:

timeout in milliseconds

setStatementTimeoutMillis

public SqlConfig setStatementTimeoutMillis(long statementTimeoutMillis)

Sets the timeout in milliseconds that is applied to statements without an explicit timeout.

It is possible to set a timeout through the SqlStatement.setTimeoutMillis(long) method. If the statement timeout is not set, then the value of this parameter will be used.

Zero value means no timeout. Negative values are prohibited.

Defaults to DEFAULT_STATEMENT_TIMEOUT_MILLIS.

Parameters:

statementTimeoutMillis - timeout in milliseconds

Returns:

this instance for chaining

See Also:

SqlStatement.setTimeoutMillis(long)

toString

public String toString()

Overrides:

toString in class Object