Mode table-fragmentation failed in check_mysql_health when use a MySQL 5.7

33 views
Skip to first unread message

CesarJ M

unread,
Jul 24, 2018, 9:04:05 AM7/24/18
to Nagios
Hi,

I'm use check_mysql_health to check MySQL status, and use MySQL 5.7.22 (the last version)
Then, when I launch this check using table-fragmentation (without database option because I use many databases, and can be created in any moment):
/usr/lib64/nagios/plugins/check_mysql_health.pl --hostname 127.0.0.1 --username root --password pass --mode table-fragmentation

Show a strange critical error:
table COLUMNS is 51200.00% fragmented, table EVENTS is 51200.00% fragmented, table OPTIMIZER_TRACE is 51200.00% fragmented, table PARAMETERS is 51200.00% fragmented, table PARTITIONS is 51200.00% fragmented, table PLUGINS is 51200.00% fragmented, table PROCESSLIST is 51200.00% fragmented, table ROUTINES is 51200.00% fragmented, table TRIGGERS is 51200.00% fragmented, table VIEWS is 51200.00% fragmented

Because show this error, 51200%?
How can it be fixed?

Regards,
Cesar Jorge

Reply all
Reply to author
Forward
0 new messages