September 2014
Intermediate to advanced
384 pages
9h 28m
English
Other storage engines offer the ability to compress tables. These engines are:
TokuDB: This engine always compresses tables; there is no way to avoid this. This is a part of its strategy, which aims to reach high performance by reducing the amount of output to disks.ARCHIVE: This storage engine is specifically designed for compressed tables with limited functionalities. It is possible to add new data to an ARCHIVE table, but the existing rows cannot be deleted or updated. Index support is very limited.MyISAM: While normal MyISAM tables are not compressed, a special tool called myisampack can be used to compress tables. A compressed MyISAM table is read only.Note that while Aria aims to be a more robust and modern ...
Read now
Unlock full access