MySQL Forums
Forum List  »  InnoDB

MySQL innodb row format compressed
Posted by: Chaitanya Tondlekar
Date: January 08, 2019 05:40AM

Hello,

We are using table level compression with the feature of row format.
Table size was approx 950GB when using row format dynamic.
After altering table to row format compressed, table size went to 350GB.

Didn't specify key block size while performing alteration on table for compression.
Default page size was 16Kb and it will get reduced to 8 KB as its half.

Now we have two different application for ingestion data into the table on two different environments.

In one of the environments, we are using same table structure with row format dynamic.

Now the observation is that
weekly growth of table size on both environments remains same.

Is the data getting inserted in compressed table would be in 8 KB of page size or default page size?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL innodb row format compressed
112
January 08, 2019 05:40AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.