When would you use InnoDB PAGE compression over InnoDB TABLE compression?

Ask Question

Asked 6 years, 9 months ago

Modified 6 years, 9 months ago

Viewed 360 times

From what I understand, InnoDB table level compression is "transparent" and appears to perform well on the surface.

In what circumstances would it be beneficial to choose InnoDB page level compression?

asked Nov 20, 2017 at 20:06

Riedsio

1,3771 gold badge14 silver badges18 bronze badges

1

I prefer having the client compress the columns that are likely to be compressible.
– Rick James
Commented Nov 20, 2017 at 21:49
1

@RickJames fair enough, I agree. But that's most often not viable after the initial design and release).
– Riedsio
Commented Nov 21, 2017 at 4:13

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.