Large number of database calls by temporal to datastax cassandra

Community Support
1

Hi,
We have setup a single node temporal cluster with cassandra on datastax. We have 0 workflows running, just barebones setup. Even with no workflows running we see 200k read and write requests per day. Is this expected out of temporal?

3

Hi, sorry for late response,

There is a number of background operations (per shard) that might result in a db query even if cluster is idle (no load). These operations are performed periodically:

TransferTaskProcessor: read to get any transfer tasks from db, performed every minute. Internal can be updated via dynamic config history.transferProcessorMaxPollInterval

TimerTaskProcessor: read to get any timer tasks from db, performed every 5 min. Interval can be changed via dynamic config history.timerProcessorMaxPollInterval

VisibilityTaskProcessor: read to get any visibility tasks from the db, performed every 1 min. Interval can be changed via dynamic config history.visibilityProcessorMaxPollInterval

UpdateShard: update to shard info table, performed every 5 min. Interval can be changed via dynamic config history.shardUpdateMinInterval

Hope this helps.