Summary
Error
admin node NMS database free table space is at zero bites
Cause
The underlying problem is with mysql v4.X and indexes being greater than the actual row counts, which results in MySQL to use more space than should be necessary.
This issue has also been observed in MySQL version 5.0 which is used in HP MAS version 8.1
Fix
Log into the NMS interface and suppress all e-mail notifications via the Grid Management -> NMS Management page, General Tab. This will prevent hundreds of e-mails being generated by the procedure that follows.
Log out of the NMS(network management system) interface and restart mi, nms and mysql as follows:
# /etc/init.d/mi stop
# /etc/init.d/nms stop
# /etc/init.d/mysql restart
# /etc/init.d/nms start
# /etc/init.d/mi start
When available, log back into the NMS and once all nodes are reconnected (none in an unknown, blue, state), re-enable e-mail notifications.
The free space will then gradually begin to increase back to normal levels.