Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 )
State: CRITICAL

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

 
discard

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

Browse other questions tagged or ask your own question.