format – MySQL DBA for Hire

Regarding MySQL 5.6 temporary tables format

default_tmp_storage_engine variable was introduced in 5.6.3, allowing the configuration of the default engine for temporary tables. This seems to be in the direction, as I commented before, of making MyISAM an optional engine. In 5.7, a separate tablespace is being

Which Compression Tool Should I Use for my Database Backups? (Part II: Decompression)

Analysis of different compression tools: Compression ratio vs decompression speed

On my post last week, I analysed some of the most common compression tools and formats, and its compression speed and ratio. While that could give us a good idea of the performance of those tools, the analysis would be