Im packing big MyISAM tables with myisampack and came up with the following issue. (MariaDB 10.1.14 64bit windows)
Indexes are rebuilt after packing the tablewhile running myisamchk -rq, so, it doesnt make sense to create/have them beforehand. After compressing a table without indexes and trying to recreate all indexes at once, i’ve noted that the table is uncompressed back.
Is there a way which i could modify the frm in a way i could rebuild the indexes without uncompressing the table?
Does MySQL use the uncompressed index in order to build the compressed index?
I will try to :
Create empty table with indexes
Hopefully myisamchk will build the indexes without ENABLE KEYS