the ghostcopy table is many times bigger than the original table

I created the mysql DB from a backup of production db.

Production had innodb_file_format parameter as Barracuda

The new environment had innodb_file_format parameter as Antelope

The ROW_FORMAT for the table in production was COMPRESSED

Unfortunately Antelope db doesn’t support ROW_FORMAT as COMPRESSED

If I had looked more into the details of information_schema, I could have resolved it eatlier!

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top