MySQL Index Usage CRITICAL

[dirk385]

Hello,

With NagiosXI we get messages MySQL Index Usage CRITICAL

I've run the repair script (/usr/local/nagiosxi/scripts/repair_databases.sh)
That solved the issue for a few minutes, after that the Critical is back again.

I also truncat the 2 tables "nagios_logentries" and "nagios_notifications".
That did not solve the issue

What I see when I run the command multiple times "/usr/local/nagios/libexec/check_mysql_health --hostname=127.0.0.1 --port=3306 --username=root --password="xxxx" --database=information_schema --mode index-usage -warning 15 --critical 20"

Is that the index usage is growing:
OK - index usage 7.95% | index_usage=7.95%;15;20 index_usage_now=62.82%
OK - index usage 7.94% | index_usage=7.94%;15;20 index_usage_now=0.00%
OK - index usage 8.69% | index_usage=8.69%;15;20 index_usage_now=26.58%
OK - index usage 8.68% | index_usage=8.68%;15;20 index_usage_now=0.00%
OK - index usage 8.78% | index_usage=8.78%;15;20 index_usage_now=58.46%
OK - index usage 8.77% | index_usage=8.77%;15;20 index_usage_now=0.00%
OK - index usage 10.67% | index_usage=10.67%;15;20 index_usage_now=31.87%
OK - index usage 10.76% | index_usage=10.76%;15;20 index_usage_now=61.54%
OK - index usage 10.75% | index_usage=10.75%;15;20 index_usage_now=0.00%
OK - index usage 10.85% | index_usage=10.85%;15;20 index_usage_now=68.25%
OK - index usage 11.30% | index_usage=11.30%;15;20 index_usage_now=24.37%
OK - index usage 11.30% | index_usage=11.30%;15;20 index_usage_now=0.00%
OK - index usage 11.34% | index_usage=11.34%;15;20 index_usage_now=43.48%
OK - index usage 13.99% | index_usage=13.99%;15;20 index_usage_now=30.15%
WARNING - index usage 15.01% | index_usage=15.01%;15;20 index_usage_now=30.29%
WARNING - index usage 15.11% | index_usage=15.11%;15;20 index_usage_now=71.95%
WARNING - index usage 15.10% | index_usage=15.10%;15;20 index_usage_now=0.00%
WARNING - index usage 15.15% | index_usage=15.15%;15;20 index_usage_now=57.81%
WARNING - index usage 15.15% | index_usage=15.15%;15;20 index_usage_now=0.00%
WARNING - index usage 15.24% | index_usage=15.24%;15;20 index_usage_now=33.33%
WARNING - index usage 15.47% | index_usage=15.47%;15;20 index_usage_now=23.93%
WARNING - index usage 16.33% | index_usage=16.33%;15;20 index_usage_now=30.60%
WARNING - index usage 18.59% | index_usage=18.59%;15;20 index_usage_now=61.45%
CRITICAL - index usage 23.09% | index_usage=23.09%;15;20 index_usage_now=58.52%

Any ideas ?

Regards,
Dirk

[scottwilkerson]

from the plugins webpage
https://labs.consol.de/nagios/check_mys ... index.html

index-usage Sum of the Index-Utilization (in contrast to Full Table Scans) 0%..100% (90:, 80:)

In this case higher numbers are better. Normally you would set your warning and critical levels followed by a : and it would be in the warning or critical level if it was BELOW that level, such as:

Code: Select all

/usr/local/nagios/libexec/check_mysql_health --hostname=127.0.0.1 --port=3306 --username=root --password="xxxx" --database=information_schema --mode index-usage -warning 30: --critical 20:

In reality I don't know how useful this particular call is going to be because the information_schema database is not heavily indexed

[dirk385]

Thx.

I was not aware of the fact that higher numbers are better.

I've adjusted the check command, now it seems fine.

[root@srv-nagios ~]# /usr/local/nagios/libexec/check_mysql_health --hostname=127.0.0.1 --port=3306 --username=root --password="xxxx" --database=information_schema --mode index-usage -warning 30: --critical 20:
OK - index usage 62.97% | index_usage=62.97%;30:;20: index_usage_now=77.47%

[scottwilkerson]

Thx.

I was not aware of the fact that higher numbers are better.

I've adjusted the check command, now it seems fine.

[root@srv-nagios ~]# /usr/local/nagios/libexec/check_mysql_health --hostname=127.0.0.1 --port=3306 --username=root --password="xxxx" --database=information_schema --mode index-usage -warning 30: --critical 20:
OK - index usage 62.97% | index_usage=62.97%;30:;20: index_usage_now=77.47%

Sounds good!

Locking thread