2
votes
2answers
789 views

Setting MySQL INNODB Compression KEY_BLOCK_SIZE

I recently started using the Barracuda InnoDB/MySQL table format which allows compression. I compressed one of my tables by running: alter table pricing row_format=compressed, key_block_size=8; ...
1
vote
2answers
87 views

Is it possible to store MySQL data as comressed?

Is it possible to store MySQL data compressed? Option for that in MySQL?
0
votes
1answer
1k views

Decompress a PSC File

I need to restore a database that was backed up using navicat's compressed backup feature. But on the restore, there's an error coming up on one of the tables. I can't look at the SQL statements in ...
0
votes
2answers
314 views

Does MySQL have an option for compressing data in its cache?

This morning I was introduced to the concept of compressing a database cache to allow a bigger cache in a given amount of RAM. I understand Microsoft SQL 2008 offers this functionality. I was ...