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?


Use the show command to see the table definition :

mysql:>show create table <table name >
  • 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 '14 at 13:59
  • @NathanJolly Thank you for the reminder, I left that out in the question.
    – Nyxynyx
    Mar 1 '14 at 1:53

Your Answer

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

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