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 ...
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 ...
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 ...
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 = ...