← Back to team overview

maria-developers team mailing list archive

Invisible Indexes and .frm Change?


Hi list.
I'm looking into adding invisible indexes.
There's 3 "scopes" I've thought of:
1) global and persistent (create table, alter table, create index)
2) global temporary (alter table t1 change index invisible global)
3) session temporary (alter table t1 change index invisible session)

#1 likely means changing the .frm format, which would cause backwardcompatibility issues.
Are there any upcoming changes to .frm planned?
Any comments or suggestions? Thanks, James Briggs.
Cassandra/MySQL DBA. Available in San Jose area or remote.
cass_top: https://github.com/jamesbriggs/cassandra-top

Follow ups