A tidbit for those of us who want to play with InnoDB compression

--=_499aaf21-b9b1-4ec4-bcbf-0161a500f7fd
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

As noted in the title, I'm messing about a bit with InnoDB compressed tables. As such, I found a rather glaring hole in the Internet: how the hell do you turn compression off again? :-D

After messing about a lot and googling until my fingers hurt, I happened upon this bug report: http://bugs.mysql.com/bug.php?id=56628

So, you turn compression on a table off by:

set session innodb_strict_mode=off;
alter table YOURTABLEHERE engine=InnoDB row_format=compact key_block_size=0;

Of course, if you're running 5.1.55+ or 5.5.9+, you'll not need to tinker with your innodb_strict_mode ; but it's still a glaring hole in the documentation.

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--=_499aaf21-b9b1-4ec4-bcbf-0161a500f7fd--

Re: A tidbit for those of us who want to play with InnoDB compression

--000e0cd25b3ee8f8b004ae78f16b
Content-Type: text/plain; charset=ISO-8859-1

Nice one Johan, thanks for the info.

On Tue, Oct 4, 2011 at 2:17 PM, Johan De Meersman wrote:

> As noted in the title, I'm messing about a bit with InnoDB compressed
> tables. As such, I found a rather glaring hole in the Internet: how the hell
> do you turn compression off again? :-D
>
> After messing about a lot and googling until my fingers hurt, I happened
> upon this bug report: http://bugs.mysql.com/bug.php?id=56628
>
> So, you turn compression on a table off by:
>
> set session innodb_strict_mode=off;
> alter table YOURTABLEHERE engine=InnoDB row_format=compact
> key_block_size=0;
>
> Of course, if you're running 5.1.55+ or 5.5.9+, you'll not need to tinker
> with your innodb_strict_mode ; but it's still a glaring hole in the
> documentation.
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>

--000e0cd25b3ee8f8b004ae78f16b--