innodb_system tablespace information missing from I_S innodb_tablespaces view

Description

  1. I am trying to explore system/default innodb tablespace encryption (ibdata1).

  2. Start percona server instance with ibdata1 encrypted.

  3. Create table that resides in ibdata1.

  4. As we can see from the running queries below it is not possible to trace if given table (in our case t1) is encrypted or not. (There is no information in tablespace that suggest innodb_system tablespace is encrypted).

  5. Also, now that encrypted = Y/N is tablespace property, querying "i_s.tables" for create_option is of no use.

Environment

None

Smart Checklist

Activity

Show:

Laurynas Biveinis March 25, 2019 at 12:51 PM

appears to be caused by this

Laurynas Biveinis March 18, 2019 at 8:19 AM

Done

Details

Assignee

Reporter

Time tracking

1d 13m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created March 12, 2019 at 6:44 AM
Updated March 6, 2024 at 12:17 PM
Resolved March 14, 2019 at 9:12 AM