We don't use read-only compressed MyISAM tables, but I found out, that by using PACK_KEYS I can save a significant amount of disk space. With some small data, the index size can be the same as the data file size, with PACK_KEYS we saved about 4/5 of the index volume (if I am right).
On Thu, 5 Aug 2021 at 11:05, Gordan Bobic <gordan.bo...@gmail.com> wrote: > InnoDB is faster even on a read-only workload now and has been for over a > decade. > One of very, very few cases for use of MyISAM is if you use compressed > read-only MyISAM tables. > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
