mysqltuner tells me to increase key_buffer_size dramatically. I dont have free memory to do it therefore I prefer to remove unnecessary indexes if any.

How can I find the memory usage of indexes? (how large a memory each index occupy)?

Is there a reporting tool or queries which can get this information ?

link|improve this question

80% accept rate
feedback

1 Answer

up vote 0 down vote accepted

Have you tried SHOW TABLE STATUS ..?

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.