After setting the various variables to enable compression on the Innodb Barracuda tables, what query will you use to check that those tables are indeed compressed?


1 Answer 1


Use the show command to see the table definition :

mysql:>show create table <table name >
  • 1
    Nyxynyx, in addition to "setting variables", you'll also need to specify compression when creating or altering a table. Then when you use Up_One's solution you should see ROW_FORMAT=COMPRESSED in the output of SHOW CREATE TABLE. Feb 28, 2014 at 13:59
  • @NathanJolly Thank you for the reminder, I left that out in the question.
    – Nyxynyx
    Mar 1, 2014 at 1:53

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.