Page Comparison

Kyvos component

Property name

Description / Value

Semantic model

Kyvos.query.resultcache.strategy

This property specifies BI Server's strategy for caching metadata and user query results.

You can set this property from the Semantic model Advance properties screen. Read more.

Kyvos.query.cuboidcache.strategy

This property specifies the cuboid cache level. This is an off-heap memory-based cache on the Query Engines. Enabling this cache helps improve the performance of queries.

You can set this property from the Semantic model Advance properties screen screen. Read more.

Query Engine

CUBOID_PURGE_FREQUENCY

This property specifies the file system purge frequency. That is, the interval after which the purge thread execution for cuboids is repeated (specified in minutes).

Syntax: CUBOID_PURGE_FREQUENCY= [>0] (int)

Default: 30

BLOCK_CACHE_LIFETIME

This property defines the lifetime of the block cache to ensure the timely removal of cuboid blocks from the global cache.

Default: 24*60 minutes (1 day) = 1440

QUERY_ENGINE_THRIFT_WORKER_THREAD

This property defines the number of worker threads from the BI Server to the Query Engine. Each query occupies one thread and in case of a multi fact query, each fact occupies one thread. This means, for a multi-fact query having five facts, a single query will consume five worker threads.

For high concurrency requirements, the value of this property should be equal to the number of expected concurrent users.

Default: 10

This means ten users can query in parallel for a single fact semantic model. All other requests will be processed in a queue.

PARALLEL_READS_PER_QUERY

This property defines the number of cuboids that each Query Engine reads in parallel for a given query. 

The default value for this property is 10, which means each Query Engine can serve up to 10 cuboids in parallel per query. You may want to reduce this number if a less number of cuboids are being queried per Query Engine per request, which will increase the locally available cache capacity for Query Engines.

Change the value of this property according to the number of users, memory per Query Engine, and the number of cuboids being queried per request per Query Engine.

BI Server

OLAP_EXEC_THREADS

This property specifies the query execution threads of the BI Server. These threads handle query execution requests. The value of this property defines the number of query execution requests that must be served simultaneously.

The default value of this property is 5. In the case of higher concurrency, the value should be set 20% more than the number of concurrent users expected. For example, for 100 concurrent users, the value of this property should be set as 120.

CUBOID_PURGE_FREQUENCY

This property specifies the file system purge frequency. That is, the interval after which the purge thread execution for cuboids is repeated (specified in minutes).

Syntax: CUBOID_PURGE_FREQUENCY= [>0] (int)

Default: 120