MySQL Forums
Forum List  »  Data Recovery

recovery with compression
Posted by: George Develekos
Date: September 19, 2018 04:00AM

Hello,
On a 5.5 server (yes we need to upgrade urgently, I know) we plan on enabling row-compression on a few InnoDB partitioned tables.

Aside from delay concerns for compressing/decompressing data as it goes in/out of the DB, are there any other potential problems?

For example, in the event of a recover after a crash, is the DB engine going to manage as well as with no compression?

Generally are there any reliability concerns that we must address before we enable compression?

Thanks for any pointers,
George

Options: ReplyQuote


Subject
Views
Written By
Posted
recovery with compression
354
September 19, 2018 04:00AM
182
September 19, 2018 12:50PM
172
September 19, 2018 01:14PM
174
September 19, 2018 02:09PM
185
September 19, 2018 02:15PM


Sorry, you can't reply to this topic. It has been closed.

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.