Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14180

Automatically disable key rotation checks for file_key_management plugin

Details

    Description

      There have been several bug reports about how the background encryption threads can use a lot of CPU. Prior analysis suggested those this is primarily caused by the operations that check for key rotation. As part of MDEV-11738, the innodb_encryption_rotate_key_age system variable's special 0 value was added to disable these checks, and this does seem to help most users.

      The default value of innodb_encryption_rotate_key_age is 1, so key rotation checks will be enabled by default. The problem is that many encryption users will be using {file_key_management}} plugin, which doesn't even support key rotations. Many of these users are not aware that they should set innodb_encryption_rotate_key_age to 0, so their background threads will be using more CPU than is necessary.

      Would it be possible to automatically disable key rotation checks for file_key_management plugin (and maybe other plugins that don't support key rotation)?

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35558 fil_crypt_must_default_encrypt() is being called even if ENCRYPTION=NO

          • Major - Major loss of function.
          • Open
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17757 MariaDB 10.1 encryption threads consume CPU 100%

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14398 When innodb_encryption_rotate_key_age=0 is set, server won't encrypt tablespaces

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29652 data-at-rest enabled high CPU use for long times

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-20713 Implement key rotation for file_key_management plugin

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24426 fil_crypt_thread keep spinning even if innodb_encryption_rotate_key_age=0

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Jan Lindström (Inactive) made transition -
            Open In Progress
            		542d 15h 12m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress Stalled
            		370d 23h 13m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            		64d 19h 10m 2
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Review
            		14d 18h 52m 1
            Marko Mäkelä made transition -
            In Review Stalled
            		58d 10h 40m 3
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Progress
            		260d 21h 56m 3
            Thirunarayanan Balathandayuthapani made transition -
            In Progress Closed
            		13d 23h 11m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.