Removing table compression leaves compressed keys
Bug #1235725 reported by
monty solomon
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Medium
|
Unassigned | |||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
Removing the compression from a table leaves KEY_BLOCK_SIZE=8 on each of the keys.
tags: | added: innodb upstream |
To post a comment you must log in.
mysql> CREATE TABLE `test` ( COMPRESSED KEY_BLOCK_SIZE=8;
-> `id` bigint(20) NOT NULL,
-> `portal_id` bigint(20) NOT NULL,
-> PRIMARY KEY (`id`),
-> UNIQUE KEY `portal_id` (`portal_id`)
-> ) ENGINE=InnoDB ROW_FORMAT=
Query OK, 0 rows affected (1.76 sec)
mysql> show create table test\G ******* ******* ****** 1. row ******* ******* ******* ****** COMPRESSED KEY_BLOCK_SIZE=8
*******
Table: test
Create Table: CREATE TABLE `test` (
`id` bigint(20) NOT NULL,
`portal_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `portal_id` (`portal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=
1 row in set (0.00 sec)
mysql> alter table test ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=0;
Query OK, 0 rows affected (0.32 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show create table test\G ******* ******* ****** 1. row ******* ******* ******* ******
*******
Table: test
Create Table: CREATE TABLE `test` (
`id` bigint(20) NOT NULL,
`portal_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`) KEY_BLOCK_SIZE=8,
UNIQUE KEY `portal_id` (`portal_id`) KEY_BLOCK_SIZE=8
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
1 row in set (0.00 sec)