• bin.x.su@oracle.com's avatar
    BUG 18117322 - DEFINE INNODB_THREAD_SLEEP_DELAY MAX VALUE · de6cdc79
    bin.x.su@oracle.com authored
    The maximum value for innodb_thread_sleep_delay is 4294967295 (32-bit) or
    18446744073709551615 (64-bit) microseconds. This is way too big, since
    the max value of innodb_thread_sleep_delay is limited by
    innodb_adaptive_max_sleep_delay if that value is set to non-zero value
    (its default is 150,000).
    
    Solution
    The maximum value of innodb_thread_sleep_delay should be the same as
    the maximum value of innodb_adaptive_max_sleep_delay, which is 1000000.
    
    Approved by Jimmy, rb#4429
    de6cdc79
ha_innodb.cc 348 KB