By adjusting this field, the administrator may improve the Supervisor's performance. The increase in threads, however, also increases Supervisor memory requirements. Be mindful of memory usage on the Supervisor after making an adjustment.
When increasing supervisor_max_threads, you must increase the max_connections value in MySQLPostgreSQL's mypostgresql.cnf conf file on the supervisor. Increasing supervisor_max_threads without also increasing MySQLthe DB's max_connections may lead to Supervisor threads that cannot communicate with the database, rendering them useless and potentially leading to lost work. MySQLThe DB's max_connections should be set to supervisor_max_threads + 100. For example, if the Supervisor's supervisor_max_threads = 128, MySQLDB's max_connections should be set to 228. By default, max_connections is set to 500, which should be sufficiently large for most cases.
- less than 100 workers: 128 threads
- 101 - 200 workers: 150 threads
- 201 - 400 workers: 250 threads
- 401 - 750 workers: 350 threads
- 751+ : 500 threads *
* We recommend you do not go above 350 threads unless the disk on which the database resides is very fast, dedicated to MySQLPostgreSQL, is local to the Supervisor, and 350 threads has proven to be too low to meet your rendering needs.