This section describes some recommended performance tuning configurations to optimize the performance of WSO2 DAS. It assumes that you have set up WSO2 DAS on a server running Unix/Linux, which is recommended for a production deployment.
| Table of Contents | ||
|---|---|---|
|
...
| Property | Description | Recommendation |
|---|---|---|
| maxActive | The maximum number of active connections that can be allocated from the connection pool at the same time. The default value is | This value should match the maximum number of requests that can be expected at a time in your production environment. This is to ensure that, whenever there is a sudden increase in the number of requests to the server, all of them can be connected successfully without causing any delays. Note that this value should not exceed the maximum number of requests allowed for your database. |
| minIdle | The minimum number of connections that can remain idle in the pool, without extra ones being created. The connection pool can shrink below this number if validation queries fail. Default value is 0. | This value should be similar or near to the average number of requests that will be received by the server at the same time. With this setting, you can avoid having to open and close new connections every time a request is received by the server. |
| testOnBorrow | The indication of whether connection objects will be validated before they are borrowed from the pool. If the object validation fails, it will be dropped from the pool, and we will attempt to borrow another connection. | Setting this property to 'true' is recommended as it will avoid connection requests from failing. The |
| validationInterval | To avoid excess validation, run validation at most at this frequency (time in milliseconds). If a connection is due for validation, but has been validated previously within this interval, it will not be validated again. The default value is | This time out can be as high as the time it takes for your DBMS to declare a connection as stale. For example, MySQL will keep a connection open for as long as 8 hours, which requires the validation interval to be within that range. However, note that having a low value for validation interval will not incur a big performance penalty, specially when database requests have a high throughput. For example, a single extra validation query run every 30 seconds is usually negligible. |
| validationQuery | The SQL query used to validate connections from this pool before returning them to the caller. If specified, this query does not have to return any data, it just can't throw an SQLException. The default value is null. Example values are SELECT 1(mysql), select 1 from dual(oracle), SELECT 1(MS Sql Server). | Specify an SQL query, which will validate the availability of a connection in the pool. This query is necessary when testOnBorrow property is true. |
...
The following parameters which affect the performance relating to receiving events are configured in the <DAS_HOME>/repository/conf/data-bridge/data-bridge-config.xml file. These configurations are common for both thrift and binary protocols.
| Property | Description | Default Value | Recommendation | ||||
|---|---|---|---|---|---|---|---|
workerThreads | The number of threads reserved to handle the load of events received. | 10 | This value should be increased if you want to increase the throughput by receiving a higher number of events at a given time. The number of available CPU cores should be considered when specifying this value. If the value specified exceeds the number of CPU cores, higher latency would occur as a result of context switching taking place more often.eventBufferCapacity | ||||
maxEventBufferCapacity | The maximum size | ofallowed for the event receiving buffer | . Thisin mega bytes. The event receiving buffer temporarily stores the events received before they are forwarded to an | /wiki/spaces/TESB/pages/32604253event stream. | 1000010 | This value should be increased | if you want to increase the throughput by receiving a higher number of eventswhen there is an increase in the receiving throughput. When increasing the value heap memory size also needs to be increased accordingly. |
eventBufferSize | The number of messages that is allowed in the receiving queue at a given time. | ||||||
| Property | Description | Recommendation | |||||
| workerThreads | Number of threads in consumer to handle the load. Default value is 10. | Value should be higher when receiving throughput is high. Should to consider number of CPU cores. | |||||
| eventBufferCapacity | Size of the receiving event buffer. Default value is 10000. | Needs to be higher value when receiving throughput is high. When increasing the value heap memory size also needs to be increased accordingly.2000 | This value should be increased when there is an increase in the receiving throughput. |
Publishing events
The following parameters which affect the performance relating to publishing events are configured in the <DAS_HOME>/repository/conf/data-bridge/data-agent-config.xml file. These configurations are common for both thrift and binary protocols.
...