when archive can support index to speed up select peformance?
Hello, when i used innodb, w/o index it will cost 2 mins for select, w/ index (two columns), it only costs 20 secs. due to large size of innodb, i convert innodb to archive engine, it save space lots, but failed to create index. previously, i want to extend primary key with those two columns, but failed due to max length should be 8 bytes. any suggestions? thanks!
Answer
Indexes in the Archive tables are not currently on the roadmap.
You can use compression that other engines support: MyISAM, XtraDB and InnoDB, TokuDB.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.