Tell me more ×
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. It's 100% free, no registration required.
up vote 1 down vote favorite

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
2  
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

closed as too localized by Mark Storey-Smith, dezso, RolandoMySQLDBA, Max Vernon, Derek Downey Apr 29 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, see the FAQ.

1 Answer

up vote 0 down vote

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

share|improve this answer
1  
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.