16 Dec
2014
16 Dec
'14
9:21 a.m.
----- 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.