In MySQL, for InnoDB engine, how do I find out the size of one of the indexes I have in the same table ?
I know I can select the index_length from information_schema.tables, but this gives the total size of all indexes in the table.
Let's suppose I have a table with PK index, several FK indexes and unique constraints, etc. Can I find out the size of one of those indexes only? Let's say, I'd like to know the size of the PK index only.