Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can i fix the Index usage on one of our database server?

It says from our Nagios control panel that:

Service: DB Index Usage
Host: MySQL Cluster 
Address: ( our IP )

Additional Info:

CRITICAL - index usage  90.01%
share|improve this question
Are you having performance problems, or are you just concerned about an arbitrary ratio set by the person who wrote a nagios check? – Aaron Brown Jun 26 '12 at 4:21
Yes i am just concerned about this alert! And this is the first time i encounter this. – Joey Jun 26 '12 at 4:58
Are you experiencing performance problems? Are there new queries in the slow log? – Aaron Brown Jun 26 '12 at 5:45
yes there is a lot of slow queries that need to optimize now.. – Joey Jun 26 '12 at 5:50
Then optimize the queries. This is a useless alert. – Aaron Brown Jun 27 '12 at 3:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.