Check whether MySQL Innodb Rows are compressed

Posted on

Question :

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?

Answer :

Use the show command to see the table definition :

mysql:>show create table <table name >

Leave a Reply

Your email address will not be published. Required fields are marked *