Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 10.1.4
-
Fix Version/s: N/A
-
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
-
Labels:None
-
Environment:Red Hat Enterprise Linux Server release 6.5
Description
I want to try the page compressed, but I can't see the effect.
This is my steps.
MariaDB [test]> set global innodb_file_format=Barracuda; Query OK, 0 rows affected (0.00 sec)
MariaDB [test]> set global innodb_compression_algorithm=zlib; Query OK, 0 rows affected (0.00 sec)
I create a table to test the page compressed.
MariaDB [test]> CREATE TABLE `T1` ( `a` int(11) DEFAULT NULL ) engine=innodb page_compressed=1;
Query OK, 0 rows affected (0.01 sec)
And I check the variables and status.
MariaDB [test]> show variables like '%compress%'; +-------------------------------------------+-------+ | Variable_name | Value | +-------------------------------------------+-------+ | have_compress | YES | | innodb_background_scrub_data_compressed | OFF | | innodb_background_scrub_data_uncompressed | OFF | | innodb_compression_algorithm | zlib | | innodb_compression_failure_threshold_pct | 5 | | innodb_compression_level | 6 | | innodb_compression_pad_pct_max | 50 | | innodb_immediate_scrub_data_uncompressed | OFF | | innodb_log_compressed_pages | OFF | | slave_compressed_protocol | OFF | +-------------------------------------------+-------+
MariaDB [test]> SHOW STATUS LIKE '%compress%'; +------------------------------------------+-------+ | Variable_name | Value | +------------------------------------------+-------+ | Compression | OFF | | Innodb_page_compression_saved | 0 | | Innodb_page_compression_trim_sect512 | 0 | | Innodb_page_compression_trim_sect1024 | 0 | | Innodb_page_compression_trim_sect2048 | 0 | | Innodb_page_compression_trim_sect4096 | 0 | | Innodb_page_compression_trim_sect8192 | 0 | | Innodb_page_compression_trim_sect16384 | 0 | | Innodb_page_compression_trim_sect32768 | 0 | | Innodb_num_pages_page_compressed | 0 | | Innodb_num_page_compressed_trim_op | 0 | | Innodb_num_page_compressed_trim_op_saved | 0 | | Innodb_num_pages_page_decompressed | 0 | | Innodb_num_pages_page_compression_error | 0 | | Innodb_defragment_compression_failures | 0 | +------------------------------------------+-------+
MariaDB [test]> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES; +-------+-------------+------+-------------+------------+-----------+---------------+ | SPACE | NAME | FLAG | FILE_FORMAT | ROW_FORMAT | PAGE_SIZE | ZIP_PAGE_SIZE | +-------+-------------+------+-------------+------------+-----------+---------------+ | 145 | test/T1 | 865 | Barracuda | Dynamic | 16384 | 0 | +-------+-------------+------+-------------+------------+-----------+---------------+
Then I insert 100MB data into T1 and check the status again.
MariaDB [test]> SHOW STATUS LIKE '%compress%'; +------------------------------------------+-------+ | Variable_name | Value | +------------------------------------------+-------+ | Compression | OFF | | Innodb_page_compression_saved | 0 | | Innodb_page_compression_trim_sect512 | 0 | | Innodb_page_compression_trim_sect1024 | 0 | | Innodb_page_compression_trim_sect2048 | 0 | | Innodb_page_compression_trim_sect4096 | 0 | | Innodb_page_compression_trim_sect8192 | 0 | | Innodb_page_compression_trim_sect16384 | 0 | | Innodb_page_compression_trim_sect32768 | 0 | | Innodb_num_pages_page_compressed | 0 | | Innodb_num_page_compressed_trim_op | 0 | | Innodb_num_page_compressed_trim_op_saved | 0 | | Innodb_num_pages_page_decompressed | 0 | | Innodb_num_pages_page_compression_error | 0 | | Innodb_defragment_compression_failures | 0 | +------------------------------------------+-------+
Why all the status still 0?
I see the status of Compression is OFF.
My step is it correct or not ?
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Duplicate of
MDEV-8250.