Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4620

Enable encryption of temporary tablespace from foreground thread

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7
    • Fix Version/s: 5.7.23-23
    • Component/s: None
    • Labels:
      None

      Description

      Current issues with temporary tablespace encryption option

      Temp tablespace is encrypted in background master thread. This creates many issues like the following

      1. SET GLOBAL innodb_temp_tablespace_encrypt=ON doesn't immediately enable encryption of temporary tablespace. Users have to wait certain period
      2. Until the master thread becomes active and puts encryption header in temporary tablespace, CREATE TEMPORARY TABLE t1() ENCRYPTION='Y' can fail. (as the tablespace is still unencrypted)
      3. the status of the variable is also confusing and it is determined by background thread
      4. Can't it turn it off or sometimes it shows wrong/misleading values.

        Attachments

          Activity

            People

            • Assignee:
              satya.bodapati Satya Bodapati
              Reporter:
              satya.bodapati Satya Bodapati
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 days, 7 minutes
                2d 7m