Nagios Support Forum

Hello Team,
Good Morning. I want to delete mysqld.logs from NAGIOS SQL server cause their size is huge , its about 20GB. i have seen these logs & they include error messages of database table crashed in it.
Is it safe to delete these logs, if yes then how can i delete these logs?

Example of logs in mysqld.log file is given below.

180305 9:49:37 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180305 9:49:37 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180305 9:49:37 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180305 9:49:37 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180305 9:49:37 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed


Regards
Jatindeep Sharma

This is showing that you actually have a database error, you should run the following repair procedure
https://assets.nagios.com/downloads/nag ... tabase.pdf


Once completed you can clear the log and free up the space by running the following:

Hello scottwilkerson,
Thanks for prompt reply.
For your information these error logs in mysqld.log file are from 2018, right now database is working fine & there is not any error in any of table(logentries, notifications & statehistory).
can i delete these logs by this command given below by you if everything is running fine & please also let me know do i have to stop mysqld service before running the command provided by you.

Regards
jatindeep sharma

Ok, you can do the following without stopping the service This clears the file while maintaining it's existence and proper permissions

Thanks scottwilkerson for your help. I have deleted the same.

Regards
Jatindeep Sharma

jatindeepsharma wrote:Thanks scottwilkerson for your help. I have deleted the same.

Regards
Jatindeep Sharma

Great!

Locking thread