[Maria-developers] 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
----- Original Message -----
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 backward compatibility issues.
Are there any upcoming changes to .frm planned?
Any comments or suggestions?
How/why are invisible indexes useful? -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
participants (2)
-
Daniel Black -
James Briggs