Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're currently using MySQL with innodb and we have some large tables that are compact in row format. When I change the row format to compressed we are still seeing the same size for the table. Anyone know the reason for this?

share|improve this question

closed as too localized by Mark Storey-Smith, dezso, RolandoMySQLDBA, Max Vernon, Derek Downey Apr 29 '13 at 20:25

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Please run SHOW CREATE TABLE tablename\G and post the output in the qustion. Also, show the ALTER TABLE command you used to compress the table. Just for clarity, please run SHOW VARIABLES LIKE 'innodb_file_per_table'; and tell us if that is on or off. – RolandoMySQLDBA Nov 30 '12 at 0:19

I got it, I just had to change the file format to barracuda

share|improve this answer
It is perfectly OK to ask and answer you own question but it would be even better if you could explain a little more about why this solution worked for you, to help future readers with a similar problem. – Paul White Nov 30 '12 at 2:03

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