Nagios Support Forums
Hello,
With Nagios get MySQL Index Usage CRITICAL by check_mysql_health.
I checked Nagios status and found the following warnings.
---
MySQL-index-usage CRITICAL 03-16-2023 13:01:13 9d 15h 13m 48s 3/3 CRITICAL - index usage 70.24%
---
I want to know how MySQL Index Usage is calculated.
Because I checked the slow log and did not find the reason for the increase in index-usage, and I confirmed that the sort scan value is not high.
I want to find out what caused the increase in index-usage
Any ideas ?
Regards,
Ian
Commercial Support Clients: Clients with support contracts can get escalated support assistance by visiting Nagios Answer Hub. These forums are for community support services. Although we at Nagios try our best to help out on the forums here, we always give priority support to our support clients.
MySQL Index Usage CRITICAL
3 posts
• Page 1 of 1
MySQL Index Usage CRITICAL
by ian_chang.y.c_tce » Thu Mar 16, 2023 12:12 am
- ian_chang.y.c_tce
- Posts: 2
- Joined: Wed Mar 15, 2023 2:05 am
Re: MySQL Index Usage CRITICAL
by kg2857 » Thu Mar 16, 2023 7:45 pm
If check_mysql_health is a script, read the script and determine what it's doing to say there's an issue. And/or you can start troubleshooting the DB backend to figure out the issue.
Approaching the issue isn't that complicated, but you have to think a little.
Approaching the issue isn't that complicated, but you have to think a little.
Think about searching the internet about your question. It will give you a million possibilities in the blink of an eye.
- kg2857
- Posts: 101
- Joined: Thu Jan 26, 2023 8:47 pm
Re: MySQL Index Usage CRITICAL
by ian_chang.y.c_tce » Fri Mar 17, 2023 1:12 am
I forgot that I can find the answer from the script, the problem has been solved now, thank you. 
- ian_chang.y.c_tce
- Posts: 2
- Joined: Wed Mar 15, 2023 2:05 am
3 posts
• Page 1 of 1
Return to Open Source Nagios Projects
Who is online
Users browsing this forum: tgriep and 18 guests
