← Back to team overview

maria-developers team 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.


References