Nagios XI DB Issues

[mkeey]

Twice this week we have had issues with our Nagios XI database. Have had to run the repair script both times (see below second ==== line).

This seems to coincide with mysqld creating and not removing some large temp files in /var/tmp/. The files are deleted but not closed so the file system isn't able to reclaim the space and the volume fills up. Since it filled again at 18:41 last night. We ran the repair and added some space as a stop-gap (see just below ==== line).

However, we would like to know what is causing the DB issue and creating TMP files that are locked causing these server outages.

===================================================================================================
When tmp fills up, we get the error:

[mcapra]

I actually just posted in another thread specifically about /var/tmp:
https://support.nagios.com/forum/viewto ... 50#p251150

A short term solution would be to expand /var/tmp. Some MySQL installations, particularly large ones, can make extensive use of that path.

It might be useful to generate a system profile (like so) and share it with the technicians here.

[cdienger]

@mkeey, feel free to pm me a profile and I can take a look at it.

[mkeey]

Thanks for the assistance. We have increased the TMP file space and are getting another XI server built so we can transfer some of the load. Please close this case as resolved - MKeey