When using MySQL, are there any guidelines for choosing VisibilityListMaxQPS?

Community Support
1

When using MySQL, are there any guidelines for choosing VisibilityListMaxQPS? The default value seems to be 1.

I am using ListClosedWorkflowExecutionsRequest to monitor the most recent completion for CronSchedule/Continuedasnew workflows.

2

VisibilityListMaxQPS aims to provide protection in case caller makes too many API calls to visibility tables and bring down the DB.

The QPS for this configuration actually depends on your setup (you DB instance configuration)

Usually, for local dev, 1 is enough. For production, you may want to override the config with proper load testing.