Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 7 rows in set (0.00 sec)
mysql> set global innodb_temp_tablespace_encrypt=ON; Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.innodb_tablespaces; ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 7 rows in set (0.00 sec)
mysql> set global innodb_temp_tablespace_encrypt=OFF; Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.innodb_tablespaces; ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 7 rows in set (0.00 sec)
mysql> select * from information_schema.innodb_tablespaces;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SPACE
NAME
FLAG
ROW_FORMAT
PAGE_SIZE
ZIP_PAGE_SIZE
SPACE_TYPE
FS_BLOCK_SIZE
FILE_SIZE
ALLOCATED_SIZE
SERVER_VERSION
SPACE_VERSION
ENCRYPTION
STATE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4294967294
mysql
18432
Any
16384
0
General
4096
24117248
24121344
8.0.16
1
N
normal
0
innodb_system
18432
Any
16384
0
System
0
0
0
8.0.16
1
N
normal
4294967293
innodb_temporary
4096
Any
16384
0
System
0
0
0
8.0.16
1
N
normal
4294967279
innodb_undo_001
0
Undo
16384
0
Undo
4096
10485760
10485760
8.0.16
1
N
active
4294967278
innodb_undo_002
0
Undo
16384
0
Undo
4096
10485760
10485760
8.0.16
1
N
active
1
sys/sys_config
16417
Dynamic
16384
0
Single
4096
114688
81920
8.0.16
1
N
normal
2
mohit/t3
16417
Dynamic
16384
0
Single
4096
114688
81920
8.0.16
1
N
normal
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)
mysql> set global innodb_temp_tablespace_encrypt=ON;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.innodb_tablespaces;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SPACE
NAME
FLAG
ROW_FORMAT
PAGE_SIZE
ZIP_PAGE_SIZE
SPACE_TYPE
FS_BLOCK_SIZE
FILE_SIZE
ALLOCATED_SIZE
SERVER_VERSION
SPACE_VERSION
ENCRYPTION
STATE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4294967294
mysql
18432
Any
16384
0
General
4096
24117248
24121344
8.0.16
1
N
normal
0
innodb_system
18432
Any
16384
0
System
0
0
0
8.0.16
1
N
normal
4294967293
innodb_temporary
4096
Any
16384
0
System
0
0
0
8.0.16
1
Y
normal
4294967279
innodb_undo_001
0
Undo
16384
0
Undo
4096
10485760
10485760
8.0.16
1
N
active
4294967278
innodb_undo_002
0
Undo
16384
0
Undo
4096
10485760
10485760
8.0.16
1
N
active
1
sys/sys_config
16417
Dynamic
16384
0
Single
4096
114688
81920
8.0.16
1
N
normal
2
mohit/t3
16417
Dynamic
16384
0
Single
4096
114688
81920
8.0.16
1
N
normal
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)
mysql> set global innodb_temp_tablespace_encrypt=OFF;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.innodb_tablespaces;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SPACE
NAME
FLAG
ROW_FORMAT
PAGE_SIZE
ZIP_PAGE_SIZE
SPACE_TYPE
FS_BLOCK_SIZE
FILE_SIZE
ALLOCATED_SIZE
SERVER_VERSION
SPACE_VERSION
ENCRYPTION
STATE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4294967294
mysql
18432
Any
16384
0
General
4096
24117248
24121344
8.0.16
1
N
normal
0
innodb_system
18432
Any
16384
0
System
0
0
0
8.0.16
1
N
normal
4294967293
innodb_temporary
4096
Any
16384
0
System
0
0
0
8.0.16
1
Y
normal
4294967279
innodb_undo_001
0
Undo
16384
0
Undo
4096
10485760
10485760
8.0.16
1
N
active
4294967278
innodb_undo_002
0
Undo
16384
0
Undo
4096
10485760
10485760
8.0.16
1
N
active
1
sys/sys_config
16417
Dynamic
16384
0
Single
4096
114688
81920
8.0.16
1
N
normal
2
mohit/t3
16417
Dynamic
16384
0
Single
4096
114688
81920
8.0.16
1
N
normal
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)