| 1 |
set global table_definition_cache=400; |
| 2 |
set global table_open_cache= 1024; |
| 3 |
use test; |
| 4 |
SET SESSION innodb_strict_mode = OFF; |
| 5 |
CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX"; |
| 6 |
Warnings: |
| 7 |
Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX' |
| 8 |
SHOW WARNINGS; |
| 9 |
Level Code Message |
| 10 |
Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX' |
| 11 |
SHOW CREATE TABLE t1; |
| 12 |
Table Create Table |
| 13 |
t1 CREATE TABLE `t1` ( |
| 14 |
`c1` int NOT NULL, |
| 15 |
PRIMARY KEY (`c1`) |
| 16 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMPRESSION='zlibX' |
| 17 |
SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; |
| 18 |
TABLE_NAME CREATE_OPTIONS |
| 19 |
t1 COMPRESSION="zlibX" |
| 20 |
SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1'; |
| 21 |
NAME ROW_FORMAT SPACE_TYPE |
| 22 |
test/t1 Dynamic Single |
| 23 |
INSERT INTO t1 VALUES(1); |
| 24 |
commit; |
| 25 |
use test; |
| 26 |
SELECT * FROM t1; |
| 27 |
c1 |
| 28 |
1 |
| 29 |
select sleep(10); |
| 30 |
sleep(10) |
| 31 |
0 |
| 32 |
# Flush tables, so that the table can be evicted by master thread. |
| 33 |
flush tables; |
| 34 |
# Create 1000 tables, try the best to evict the table. |
| 35 |
sleep(20) |
| 36 |
0 |
| 37 |
Warnings: |
| 38 |
Warning 1525 Incorrect COMPRESSION value: 'zlibX' |
| 39 |
Level Code Message |
| 40 |
Warning 1525 Incorrect COMPRESSION value: 'zlibX' |
| 41 |
set global table_definition_cache=default; |
| 42 |
set global table_open_cache= default; |