New answers tagged compression
Here are some thoughts on this: Do you know that you should get better compression on the strings that you have tested with? Have you tested those same strings by gzipping outside of .NET? Such as on Linux / CygWin -- DOS port of UNIX utilities / PHP / etc? If you have updated your system with .NET 4.5, then you are using the updated GZipStream. This is ...
If innodb_file_per_table is enabled, then a temp table is being populated with the new compression. The original table is currently intact, just not writable. Running KILL QUERY 12345 on the Connection running the ALTER TABLE should do the following: release the write lock drop the temp table leave the original table as is
Top 50 recent answers are included