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?

  • 1
    I prefer having the client compress the columns that are likely to be compressible. – Rick James Nov 20 '17 at 21:49
  • 1
    @RickJames fair enough, I agree. But that's most often not viable after the initial design and release). – Riedsio Nov 21 '17 at 4:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.