• Marko Mäkelä's avatar
    MDEV-22258 Limit innodb_encryption_threads to 255 · 6b2c8cac
    Marko Mäkelä authored
    For no good reason, innodb_encryption_threads was limited to
    4,294,967,295. Expectedly, the server would crash if such an
    insane value was specified. Let us limit the maximum to 255.
    
    The encryption threads are not doing much useful work.
    They are basically only dirtying pages by performing
    dummy writes via the redo log. The encryption key rotation
    or the in-place addition or removal of encryption
    will take place in the page cleaner.
    
    In a quick test on a 20-core CPU (40 threads in total),
    the sweet spot on an otherwise idle server seemed to be
    innodb_encryption_threads=16 for the test
    encryption.encrypt_and_grep. The new limit 255 should be
    more than enough for even bigger servers.
    6b2c8cac
sysvars_innodb.result 71.2 KB