SELECT b.name,a.name,index_id,type,a.space,a.page_no
from information_schema.innodb_sys_indexes a,
information_schema.innodb_sys_tables b
where a.table_id=b.table_id and a.space <>0 ;
SELECT b.name,a.name,index_id,type,a.space,a.page_no
from information_schema.innodb_sys_indexes a,
information_schema.innodb_sys_tables b
where a.table_id=b.table_id and a.space <>0 ;