You are viewing an old version of this page. View the current version.

    Compare with Current View Page History

    Version 1 Next »

    Synopsis

    The total number of Supervisor threads, the upper bound on the size of the supervisor thread pool.  This may contain idle supervisor threads.

    supervisor_max_threads = threads

    Note: This does not include the 7 additional threads the Supervisor opens to identify idle hosts ready to run jobs, contact dead Workers, and to execute time-based events.

    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.

    MySQL max_connections

    Icon

    When increasing supervisor_max_threads, one must increase the max_connections value in MySQL's my.cnf on the supervisor. Increasing supervisor_max_threads without also increasing MySQL's max_connections may lead to supervisor threads that cannot communicate with the database, rendering them useless and potentially leading to lost work. MySQL's max_connections should be set to supervisor_max_threads + 100. For example, if the supervisor's supervisor_max_threads = 128, MySQL's max_connections should be set to 228.

    Recommendations

    • 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 MySQL, is local to the supervisor, and 350 threads has proven to be too low to meet your rendering needs.

    Example

    supervisor_max_threads = 64

    Defaults

    128

    • No labels