5 Aug
2021
5 Aug
'21
11:10 a.m.
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.bobic@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.