0

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?

Thanks!

Alex

  • Creating index on MyISAM table means doing full alter iirc - effectively it creates a new table and copies all rows into it. You might instead want to disable (secondary) indexes during these operations and then enable them when done (that should trigger a faster rebuild by sorting). – jkavalik Jun 15 '16 at 18:49
0

I will try to :

Create empty table with indexes DISABLE KEYS Load Data myisampack table myisamchk -rq

Hopefully myisamchk will build the indexes without ENABLE KEYS

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.