MariaDB [test]> select @@version;
|
+-----------------+
|
| @@version |
|
+-----------------+
|
| 10.3.23-MariaDB |
|
+-----------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> create table tab1 (a int) page_compressed='on';
|
Query OK, 0 rows affected (0.025 sec)
|
|
MariaDB [test]> create table tab2 (a int) page_compressed='on', page_compression_level=1;
|
Query OK, 0 rows affected (0.016 sec)
|
|
MariaDB [test]> show create table tab1;
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| tab1 | CREATE TABLE `tab1` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 `page_compressed`='on' |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> show create table tab2;
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------+
|
| tab2 | CREATE TABLE `tab2` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 `page_compressed`='on' `page_compression_level`=1 |
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> insert into tab1 values (1),(1),(1);
|
Query OK, 3 rows affected (0.002 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> insert into tab2 values (1),(1),(1);
|
Query OK, 3 rows affected (0.003 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> alter table tab1 page_compressed='off';
|
Query OK, 0 rows affected (0.022 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> alter table tab2 page_compressed='off';
|
ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'PAGE_COMPRESSION_LEVEL'
|
|
MariaDB [test]> show create table tab1;
|
+-------+-----------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-----------------------------------------------------------------------------------------------------------------+
|
| tab1 | CREATE TABLE `tab1` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 `page_compressed`='off' |
|
+-------+-----------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> show create table tab2;
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------+
|
| tab2 | CREATE TABLE `tab2` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 `page_compressed`='on' `page_compression_level`=1 |
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|