maria-developers team mailing list archive
Mailing list archive
Re: Invisible Indexes and .frm Change?
----- 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.