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 ?
From serverfault
Niro
-
Have you tried SHOW TABLE STATUS ..?
From danlefree
0 comments:
Post a Comment