The name given to the process of encoding data such that it uses lesser number of bits as compared to the original representation.

learn more… | top users | synonyms

4
votes
1answer
143 views

Page compression not working?

I have created a table where I have around 100 partitions (per month), all of them are configured to use page compression. After that I'm inserting data to this table month by month. I now would ...
0
votes
1answer
125 views

Mongo Db server status with wired Tiger

I was testing my DB with Mongo 3.0 wiredTiger setup. After restoring my database with wiredTIger i ran db.serverStatus. I found following in console output. "bytes currently in the cache" : ...
0
votes
1answer
28 views

Will canceling InnoDB compression that's already in progress corrupt data?

I have a 155GB table that is in the process of being compressed. ALTER TABLE $table_name ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; This compression has been running for a long time and is impeding my ...
2
votes
0answers
424 views

Understanding how sys.dm_exec_requests represents queries being rolled back

I'm not sure whether this was an actual problem or just a normal situation where I needed to wait for rollback to finish. In either case, some insight would be appreciated. Background details I ...
0
votes
0answers
21 views

Estimating file growth when compressing tables

I have some databases that I will compress these days with the compression feature in SQL Server. I did this in a local environment with a 1GB database, and the MDF file grows 10%. In the production ...
0
votes
0answers
31 views

Backup File Size Almost 50% of Database File Size with TDE Enabled

I'm really hoping someone can help shed some light on this for me. I receive a full backup of a very large database once per week from a vendor. It contains transactional data which we then load into ...
0
votes
0answers
33 views

MySQL blob removes last bites when selecting in some strings

When I retrieve blob it get cut from the end a little. Most strings are ok, but some got cropped for several last charecters. echo $data, '<br />'; db_execute("UPDATE table SET blobcolumn = ...