Skip to content
  • Rahul Agarkar's avatar
    0f05c270
    WL#11613: InnoDB: Reclaim disk space occupied by temporary tables online · 0f05c270
    Rahul Agarkar authored
    - Added support for creating and managing the Session Temporary Tablespace
      pool. The temporary tablespaces in this pool will be used to store
      all the user temporary tables as well as optimizer internal temporary
      tables
    - Added support to reclaim the disk space occupied by the user and
      optimizer internal temporary tables on a session disconnect
    - Added new server option innodb_temp_tablespaces_dir to specify the
      the directory to hold the session temporary tablespaces
    - Added a new table INFORMATION_SCHEMA.INNODB_SESSION_TEMP_TABLESPACES
      to track the usage of the session temporary tablespaces
    - Added deprecation warnings for TABLESPACE=innodb_file_per_table and
      TABLESPACE=innodb_temporary phrases while creating a temporary table
      using CREATE TEMPORARY TABLE statement
    
    Reviewed by: Kevin Lewis <kevin.lewis@oracle.com>
                 Annamalai Gurusami <annamalai.gurusami@oracle.com>
    
    RB: 19798
    0f05c270
    WL#11613: InnoDB: Reclaim disk space occupied by temporary tables online
    Rahul Agarkar authored
    - Added support for creating and managing the Session Temporary Tablespace
      pool. The temporary tablespaces in this pool will be used to store
      all the user temporary tables as well as optimizer internal temporary
      tables
    - Added support to reclaim the disk space occupied by the user and
      optimizer internal temporary tables on a session disconnect
    - Added new server option innodb_temp_tablespaces_dir to specify the
      the directory to hold the session temporary tablespaces
    - Added a new table INFORMATION_SCHEMA.INNODB_SESSION_TEMP_TABLESPACES
      to track the usage of the session temporary tablespaces
    - Added deprecation warnings for TABLESPACE=innodb_file_per_table and
      TABLESPACE=innodb_temporary phrases while creating a temporary table
      using CREATE TEMPORARY TABLE statement
    
    Reviewed by: Kevin Lewis <kevin.lewis@oracle.com>
                 Annamalai Gurusami <annamalai.gurusami@oracle.com>
    
    RB: 19798
Loading