I've attempted to find a good way to audit indexes that exist in MySQL vs those reported by InnoDB. It's definitely a large undertaking due to the number of tables we have. Querying the information_schema INNODB tables for index information proved extremely resource intensive and ended up locking up the replication thread and eventually the entire server instance. I think I could pull a lot of that data out onto a different test box and analyze it though.
Hey Ovais,
I've attempted to find a good way to audit indexes that exist in MySQL vs those reported by InnoDB. It's definitely a large undertaking due to the number of tables we have. Querying the information_schema INNODB tables for index information proved extremely resource intensive and ended up locking up the replication thread and eventually the entire server instance. I think I could pull a lot of that data out onto a different test box and analyze it though.
Any other ideas for comparing indexes?