We have a very large MySQL InnoDB database, compressed using the following syntax at the end of the table declaration:
ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
We also have windows compression enabled on the logical disk drive that the database resides. It is an 800GB SSD hard drive. The drive is used solely for the database, no other files reside on it.
Does having the two compressions enabled help to save more space, or is it hurting or not beneficial at all?