1

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 ?

1 Answer 1

0

Have you tried SHOW TABLE STATUS ..?

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .