• Marko Mäkelä's avatar
    MDEV-11984 Avoid accessing SYS_TABLESPACES unnecessarily · 2fb31821
    Marko Mäkelä authored
    The following INFORMATION_SCHEMA views were unnecessarily retrieving
    the data from the SYS_TABLESPACES table instead of directly fetching
    it from the fil_system cache:
    
    information_schema.innodb_tablespaces_encryption
    information_schema.innodb_tablespaces_scrubbing
    
    InnoDB always loads all tablespace metadata into memory at startup
    and never evicts it while the tablespace exists.
    
    With this fix, accessing these views will be much faster and use less
    memory, and include data about all tablespaces, including undo
    tablespaces.
    
    The view information_schema.innodb_sys_tablespaces will still reflect
    the contents of the SYS_TABLESPACES table.
    2fb31821
innodb_encryption.result 3 KB