Root partition getting occupied with log files and MYD MYI files

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Post Reply
pavan509
Posts: 72
Joined: Fri Apr 30, 2021 7:07 am

Root partition getting occupied with log files and MYD MYI files

Post by pavan509 »

Hello Team,

I could see the below files are increasing their size day by day and are causing root partition full. May I know what are these files and what is the importance of this.

Code: Select all

sudo du -sh /usr/local/nagios/var/archives/* | sort -rh
1.1G    /usr/local/nagios/var/archives/nagios-07-05-2024-00.log
298M    /usr/local/nagios/var/archives/nagios-07-06-2024-00.log
151M    /usr/local/nagios/var/archives/nagios-07-07-2024-00.log
150M    /usr/local/nagios/var/archives/nagios-07-08-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-13-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-12-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-11-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-10-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-09-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-08-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-07-2024-00.log
12M     /usr/local/nagios/var/archives/nagios-06-14-2024-00.log
12M     /usr/local/nagios/var/archives/nagios-06-06-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-04-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-03-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-02-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-01-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-06-30-2024-00.log

Code: Select all

sudo du -sh /var/lib/mysql/* | sort -rh
860M    /var/lib/mysql/nagios
101M    /var/lib/mysql/#innodb_redo
64M     /var/lib/mysql/nagiosxi
27M     /var/lib/mysql/mysql.ibd
16M     /var/lib/mysql/undo_002
16M     /var/lib/mysql/undo_001
12M     /var/lib/mysql/ibtmp1
12M     /var/lib/mysql/ibdata1
8.2M    /var/lib/mysql/#ib_16384_1.dblwr
2.6M    /var/lib/mysql/nagiosql
1.7M    /var/lib/mysql/performance_schema
800K    /var/lib/mysql/#innodb_temp
192K    /var/lib/mysql/#ib_16384_0.dblwr
112K    /var/lib/mysql/sys
32K     /var/lib/mysql/mysql
24K     /var/lib/mysql/ib_buffer_pool
4.0K    /var/lib/mysql/server-key.pem
4.0K    /var/lib/mysql/server-cert.pem
4.0K    /var/lib/mysql/public_key.pem
4.0K    /var/lib/mysql/private_key.pem
4.0K    /var/lib/mysql/mysqlx.sock.lock
4.0K    /var/lib/mysql/mysql_upgrade_info
4.0K    /var/lib/mysql/mysql.sock.lock
4.0K    /var/lib/mysql/client-key.pem
4.0K    /var/lib/mysql/client-cert.pem
4.0K    /var/lib/mysql/ca.pem
4.0K    /var/lib/mysql/ca-key.pem
4.0K    /var/lib/mysql/binlog.index
4.0K    /var/lib/mysql/binlog.000002
4.0K    /var/lib/mysql/binlog.000001
4.0K    /var/lib/mysql/auto.cnf
0       /var/lib/mysql/mysqlx.sock
0       /var/lib/mysql/mysql.sock

Code: Select all

sudo ls -lth /var/lib/mysql/nagios/
total 861M
-rw-r----- 1 mysql mysql  3.3M Jul  8 08:24 nagios_notifications.MYI
-rw-r----- 1 mysql mysql   66M Jul  8 08:24 nagios_contactnotificationmethods.MYI
-rw-r----- 1 mysql mysql   52M Jul  8 08:24 nagios_contactnotifications.MYD
-rw-r----- 1 mysql mysql   82M Jul  8 08:24 nagios_contactnotifications.MYI
-rw-r----- 1 mysql mysql   15M Jul  8 08:24 nagios_notifications.MYD
-rw-r----- 1 mysql mysql   63M Jul  8 08:24 nagios_contactnotificationmethods.MYD
-rw-r----- 1 mysql mysql   12K Jul  8 08:24 nagios_systemcommands.MYI
-rw-r----- 1 mysql mysql   27K Jul  8 08:24 nagios_systemcommands.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:24 nagios_programstatus.MYI
-rw-r----- 1 mysql mysql   116 Jul  8 08:24 nagios_programstatus.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:22 nagios_eventhandlers.MYI
-rw-r----- 1 mysql mysql  1.2K Jul  8 08:20 nagios_eventhandlers.MYD
-rw-r----- 1 mysql mysql   20M Jul  8 08:20 nagios_statehistory.MYI
-rw-r----- 1 mysql mysql   52M Jul  8 08:20 nagios_statehistory.MYD
-rw-r----- 1 mysql mysql  625K Jul  8 08:11 nagios_objects.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:10 nagios_contactstatus.MYI
-rw-r----- 1 mysql mysql  4.0K Jul  8 08:10 nagios_configfilevariables.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_comments.MYI
-rw-r----- 1 mysql mysql  7.0K Jul  8 08:09 nagios_configfilevariables.MYD
-rw-r----- 1 mysql mysql  9.0K Jul  8 08:09 nagios_configfiles.MYI
-rw-r----- 1 mysql mysql    44 Jul  8 08:09 nagios_configfiles.MYD
-rw-r----- 1 mysql mysql   904 Jul  8 08:09 nagios_runtimevariables.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_runtimevariables.MYI
-rw-r----- 1 mysql mysql   19K Jul  8 08:09 nagios_servicegroup_members.MYI
-rw-r----- 1 mysql mysql  8.3K Jul  8 08:09 nagios_servicegroup_members.MYD
-rw-r----- 1 mysql mysql  4.5K Jul  8 08:09 nagios_comments.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_servicegroups.MYI
-rw-r----- 1 mysql mysql   276 Jul  8 08:09 nagios_servicegroups.MYD
-rw-r----- 1 mysql mysql  678K Jul  8 08:09 nagios_objects.MYD
-rw-r----- 1 mysql mysql   37K Jul  8 08:09 nagios_customvariablestatus.MYI
-rw-r----- 1 mysql mysql   38K Jul  8 08:09 nagios_customvariablestatus.MYD
-rw-r----- 1 mysql mysql   34K Jul  8 08:09 nagios_customvariables.MYI
-rw-r----- 1 mysql mysql   37K Jul  8 08:09 nagios_customvariables.MYD
-rw-r----- 1 mysql mysql  7.0K Jul  8 08:09 nagios_service_contacts.MYI
-rw-r----- 1 mysql mysql  1.7K Jul  8 08:09 nagios_service_contacts.MYD
-rw-r----- 1 mysql mysql   78K Jul  8 08:09 nagios_service_contactgroups.MYI
-rw-r----- 1 mysql mysql   41K Jul  8 08:09 nagios_service_contactgroups.MYD
-rw-r----- 1 mysql mysql   48K Jul  8 08:09 nagios_processevents.MYI
-rw-r----- 1 mysql mysql   23K Jul  8 08:09 nagios_services.MYI
-rw-r----- 1 mysql mysql  5.0K Jul  8 08:09 nagios_hostgroup_members.MYI
-rw-r----- 1 mysql mysql  1.2K Jul  8 08:09 nagios_hostgroup_members.MYD
-rw-r----- 1 mysql mysql   304 Jul  8 08:09 nagios_hostgroups.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_hostgroups.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_host_contacts.MYI
-rw-r----- 1 mysql mysql   165 Jul  8 08:09 nagios_host_contacts.MYD
-rw-r----- 1 mysql mysql  9.0K Jul  8 08:09 nagios_host_contactgroups.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_host_contactgroups.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_hosts.MYI
-rw-r----- 1 mysql mysql  5.0K Jul  8 08:09 nagios_contactgroup_members.MYI
-rw-r----- 1 mysql mysql  1.3K Jul  8 08:09 nagios_contactgroup_members.MYD
-rw-r----- 1 mysql mysql  1.8K Jul  8 08:09 nagios_contactstatus.MYD
-rw-r----- 1 mysql mysql   252 Jul  8 08:09 nagios_contactgroups.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_contactgroups.MYI
-rw-r----- 1 mysql mysql  5.0K Jul  8 08:09 nagios_contact_notificationcommands.MYI
-rw-r----- 1 mysql mysql  1.9K Jul  8 08:09 nagios_contact_notificationcommands.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_contact_addresses.MYI
-rw-r----- 1 mysql mysql   900 Jul  8 08:09 nagios_contact_addresses.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_contacts.MYI
-rw-r----- 1 mysql mysql   190 Jul  8 08:09 nagios_timeperiod_exception_timeranges.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_timeperiod_exception_timeranges.MYI
-rw-r----- 1 mysql mysql   350 Jul  8 08:09 nagios_timeperiod_exceptions.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_timeperiod_exceptions.MYI
-rw-r----- 1 mysql mysql   15K Jul  8 08:09 nagios_timeperiod_timeranges.MYI
-rw-r----- 1 mysql mysql  7.5K Jul  8 08:09 nagios_timeperiod_timeranges.MYD
-rw-r----- 1 mysql mysql  2.7K Jul  8 08:09 nagios_timeperiods.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_timeperiods.MYI
-rw-r----- 1 mysql mysql   19K Jul  8 08:09 nagios_commands.MYD
-rw-r----- 1 mysql mysql  8.0K Jul  8 08:09 nagios_commands.MYI
-rw-r----- 1 mysql mysql  234K Jul  8 08:09 nagios_processevents.MYD
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_timeperiod_exclusions.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_timeperiod_exclusions.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_serviceescalation_contactgroups.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_serviceescalation_contactgroups.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostescalation_contactgroups.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostescalation_contactgroups.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_host_parenthosts.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_service_parentservices.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_service_parentservices.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_host_parenthosts.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_servicedependencies.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostdependencies.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostdependencies.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_servicedependencies.MYD
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_serviceescalation_contacts.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_serviceescalation_contacts.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_serviceescalations.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostescalation_contacts.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostescalation_contacts.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostescalations.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostescalations.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_serviceescalations.MYD
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_scheduleddowntime.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_scheduleddowntime.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_timedeventqueue.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_timedeventqueue.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_timedevents.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_servicechecks.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 07:25 nagios_instances.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_hostchecks.MYI
-rw-r----- 1 mysql mysql  321K Jul  8 07:25 nagios_flappinghistory.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_externalcommands.MYI
-rw-r----- 1 mysql mysql   91K Jul  8 07:25 nagios_downtimehistory.MYI
-rw-r----- 1 mysql mysql   34K Jul  8 07:25 nagios_conninfo.MYI
-rw-r----- 1 mysql mysql  362K Jul  8 07:25 nagios_commenthistory.MYI
-rw-r----- 1 mysql mysql  351K Jul  8 07:25 nagios_acknowledgements.MYI
-rw-r----- 1 mysql mysql  3.0M Jul  8 02:10 nagios_commenthistory.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  4 17:50 nagios_dbversion.MYI
-rw-r----- 1 mysql mysql  198K Jul  4 17:00 nagios_servicestatus.MYI
-rw-r----- 1 mysql mysql   21K Jul  4 16:58 nagios_hoststatus.MYI
-rw-r----- 1 mysql mysql   13K Jul  4 16:58 nagios_hoststatus.MYD
-rw-r----- 1 mysql mysql   96M Jul  4 16:57 nagios_logentries.MYI
-rw-r----- 1 mysql mysql     0 Jul  4 16:56 nagios_timedevents.MYD
-rw-r----- 1 mysql mysql  279K Jul  4 16:56 nagios_servicestatus.MYD
-rw-r----- 1 mysql mysql  163K Jul  4 16:56 nagios_services.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:56 nagios_servicechecks.MYD
-rw-r----- 1 mysql mysql  2.0K Jul  4 16:56 nagios_regions.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  4 16:56 nagios_rebalance_affected_instances.MYI
-rw-r----- 1 mysql mysql    44 Jul  4 16:56 nagios_regions.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:56 nagios_rebalance_affected_instances.MYD
-rw-r----- 1 mysql mysql  402M Jul  4 16:55 nagios_logentries.MYD
-rw-r----- 1 mysql mysql   108 Jul  4 16:55 nagios_instances.MYD
-rw-r----- 1 mysql mysql   13K Jul  4 16:55 nagios_hosts.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:55 nagios_hostchecks.MYD
-rw-r----- 1 mysql mysql  1.8M Jul  4 16:55 nagios_flappinghistory.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:55 nagios_externalcommands.MYD
-rw-r----- 1 mysql mysql  416K Jul  4 16:55 nagios_downtimehistory.MYD
-rw-r----- 1 mysql mysql    20 Jul  4 16:55 nagios_dbversion.MYD
-rw-r----- 1 mysql mysql  4.3K Jul  4 16:55 nagios_contacts.MYD
-rw-r----- 1 mysql mysql  285K Jul  4 16:55 nagios_conninfo.MYD
-rw-r----- 1 mysql mysql 1014K Jul  4 16:55 nagios_acknowledgements.MYD
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_timeperio_4898.sdi
-rw-r----- 1 mysql mysql  6.5K Apr 30 15:13 nagios_timeperio_4897.sdi
-rw-r----- 1 mysql mysql  2.8K Apr 30 15:13 nagios_timeperio_4896.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_timeperio_4895.sdi
-rw-r----- 1 mysql mysql  5.5K Apr 30 15:13 nagios_timeperio_4894.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_timedeven_4893.sdi
-rw-r----- 1 mysql mysql  9.3K Apr 30 15:13 nagios_timedeven_4892.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_systemcom_4891.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_statehist_4890.sdi
-rw-r----- 1 mysql mysql   56K Apr 30 15:13 nagios_servicest_4889.sdi
-rw-r----- 1 mysql mysql   74K Apr 30 15:13 nagios_services_4888.sdi
-rw-r----- 1 mysql mysql   20K Apr 30 15:13 nagios_servicegr_4887.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_servicegr_4886.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_servicees_4885.sdi
-rw-r----- 1 mysql mysql  4.9K Apr 30 15:13 nagios_servicees_4884.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_servicees_4883.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_servicede_4882.sdi
-rw-r----- 1 mysql mysql   29K Apr 30 15:13 nagios_servicech_4881.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_service_p_4880.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_service_c_4879.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_service_c_4878.sdi
-rw-r----- 1 mysql mysql   35K Apr 30 15:13 nagios_scheduled_4877.sdi
-rw-r----- 1 mysql mysql  9.2K Apr 30 15:13 nagios_runtimeva_4876.sdi
-rw-r----- 1 mysql mysql  4.4K Apr 30 15:13 nagios_regions_4875.sdi
-rw-r----- 1 mysql mysql  2.9K Apr 30 15:13 nagios_rebalance_4874.sdi
-rw-r----- 1 mysql mysql   24K Apr 30 15:13 nagios_programst_4873.sdi
-rw-r----- 1 mysql mysql  8.4K Apr 30 15:13 nagios_processev_4872.sdi
-rw-r----- 1 mysql mysql   16K Apr 30 15:13 nagios_objects_4871.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_notificat_4870.sdi
-rw-r----- 1 mysql mysql  9.6K Apr 30 15:13 nagios_logentrie_4869.sdi
-rw-r----- 1 mysql mysql  7.2K Apr 30 15:13 nagios_instances_4868.sdi
-rw-r----- 1 mysql mysql   55K Apr 30 15:13 nagios_hoststatu_4867.sdi
-rw-r----- 1 mysql mysql   89K Apr 30 15:13 nagios_hosts_4866.sdi
-rw-r----- 1 mysql mysql   20K Apr 30 15:13 nagios_hostgroup_4865.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_hostgroup_4864.sdi
-rw-r----- 1 mysql mysql   11K Apr 30 15:13 nagios_hostescal_4863.sdi
-rw-r----- 1 mysql mysql  4.9K Apr 30 15:13 nagios_hostescal_4862.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_hostescal_4861.sdi
-rw-r----- 1 mysql mysql   11K Apr 30 15:13 nagios_hostdepen_4860.sdi
-rw-r----- 1 mysql mysql   29K Apr 30 15:13 nagios_hostcheck_4859.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_host_pare_4858.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_host_cont_4857.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_host_cont_4856.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_flappingh_4855.sdi
-rw-r----- 1 mysql mysql   15K Apr 30 15:13 nagios_externalc_4854.sdi
-rw-r----- 1 mysql mysql   25K Apr 30 15:13 nagios_eventhand_4853.sdi
-rw-r----- 1 mysql mysql   38K Apr 30 15:13 nagios_downtimeh_4852.sdi
-rw-r----- 1 mysql mysql  2.5K Apr 30 15:13 nagios_dbversion_4851.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_customvar_4850.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_customvar_4849.sdi
-rw-r----- 1 mysql mysql   11K Apr 30 15:13 nagios_contactst_4848.sdi
-rw-r----- 1 mysql mysql   32K Apr 30 15:13 nagios_contacts_4847.sdi
-rw-r----- 1 mysql mysql  8.8K Apr 30 15:13 nagios_contactno_4846.sdi
-rw-r----- 1 mysql mysql   18K Apr 30 15:13 nagios_contactno_4845.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_contactgr_4844.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_contactgr_4843.sdi
-rw-r----- 1 mysql mysql   15K Apr 30 15:13 nagios_contact_n_4842.sdi
-rw-r----- 1 mysql mysql  6.6K Apr 30 15:13 nagios_contact_a_4841.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_conninfo_4840.sdi
-rw-r----- 1 mysql mysql  9.5K Apr 30 15:13 nagios_configfil_4839.sdi
-rw-r----- 1 mysql mysql  5.9K Apr 30 15:13 nagios_configfil_4838.sdi
-rw-r----- 1 mysql mysql   34K Apr 30 15:13 nagios_comments_4837.sdi
-rw-r----- 1 mysql mysql   36K Apr 30 15:13 nagios_commenthi_4836.sdi
-rw-r----- 1 mysql mysql  5.6K Apr 30 15:13 nagios_commands_4835.sdi
-rw-r----- 1 mysql mysql   32K Apr 30 15:13 nagios_acknowled_4834.sdi
Thanks, Pavan
kg2857
Posts: 499
Joined: Wed Apr 12, 2023 5:48 pm

Re: Root partition getting occupied with log files and MYD MYI files

Post by kg2857 »

Maybe use logrotate to clean the files, or grow the FS.
sgardil
Posts: 355
Joined: Wed Aug 09, 2023 9:58 am

Re: Root partition getting occupied with log files and MYD MYI files

Post by sgardil »

pavan509 wrote: Mon Jul 08, 2024 1:26 am Hello Team,

I could see the below files are increasing their size day by day and are causing root partition full. May I know what are these files and what is the importance of this.

Code: Select all

sudo du -sh /usr/local/nagios/var/archives/* | sort -rh
1.1G    /usr/local/nagios/var/archives/nagios-07-05-2024-00.log
298M    /usr/local/nagios/var/archives/nagios-07-06-2024-00.log
151M    /usr/local/nagios/var/archives/nagios-07-07-2024-00.log
150M    /usr/local/nagios/var/archives/nagios-07-08-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-13-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-12-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-11-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-10-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-09-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-08-2024-00.log
15M     /usr/local/nagios/var/archives/nagios-06-07-2024-00.log
12M     /usr/local/nagios/var/archives/nagios-06-14-2024-00.log
12M     /usr/local/nagios/var/archives/nagios-06-06-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-04-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-03-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-02-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-07-01-2024-00.log
11M     /usr/local/nagios/var/archives/nagios-06-30-2024-00.log

Code: Select all

sudo du -sh /var/lib/mysql/* | sort -rh
860M    /var/lib/mysql/nagios
101M    /var/lib/mysql/#innodb_redo
64M     /var/lib/mysql/nagiosxi
27M     /var/lib/mysql/mysql.ibd
16M     /var/lib/mysql/undo_002
16M     /var/lib/mysql/undo_001
12M     /var/lib/mysql/ibtmp1
12M     /var/lib/mysql/ibdata1
8.2M    /var/lib/mysql/#ib_16384_1.dblwr
2.6M    /var/lib/mysql/nagiosql
1.7M    /var/lib/mysql/performance_schema
800K    /var/lib/mysql/#innodb_temp
192K    /var/lib/mysql/#ib_16384_0.dblwr
112K    /var/lib/mysql/sys
32K     /var/lib/mysql/mysql
24K     /var/lib/mysql/ib_buffer_pool
4.0K    /var/lib/mysql/server-key.pem
4.0K    /var/lib/mysql/server-cert.pem
4.0K    /var/lib/mysql/public_key.pem
4.0K    /var/lib/mysql/private_key.pem
4.0K    /var/lib/mysql/mysqlx.sock.lock
4.0K    /var/lib/mysql/mysql_upgrade_info
4.0K    /var/lib/mysql/mysql.sock.lock
4.0K    /var/lib/mysql/client-key.pem
4.0K    /var/lib/mysql/client-cert.pem
4.0K    /var/lib/mysql/ca.pem
4.0K    /var/lib/mysql/ca-key.pem
4.0K    /var/lib/mysql/binlog.index
4.0K    /var/lib/mysql/binlog.000002
4.0K    /var/lib/mysql/binlog.000001
4.0K    /var/lib/mysql/auto.cnf
0       /var/lib/mysql/mysqlx.sock
0       /var/lib/mysql/mysql.sock

Code: Select all

sudo ls -lth /var/lib/mysql/nagios/
total 861M
-rw-r----- 1 mysql mysql  3.3M Jul  8 08:24 nagios_notifications.MYI
-rw-r----- 1 mysql mysql   66M Jul  8 08:24 nagios_contactnotificationmethods.MYI
-rw-r----- 1 mysql mysql   52M Jul  8 08:24 nagios_contactnotifications.MYD
-rw-r----- 1 mysql mysql   82M Jul  8 08:24 nagios_contactnotifications.MYI
-rw-r----- 1 mysql mysql   15M Jul  8 08:24 nagios_notifications.MYD
-rw-r----- 1 mysql mysql   63M Jul  8 08:24 nagios_contactnotificationmethods.MYD
-rw-r----- 1 mysql mysql   12K Jul  8 08:24 nagios_systemcommands.MYI
-rw-r----- 1 mysql mysql   27K Jul  8 08:24 nagios_systemcommands.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:24 nagios_programstatus.MYI
-rw-r----- 1 mysql mysql   116 Jul  8 08:24 nagios_programstatus.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:22 nagios_eventhandlers.MYI
-rw-r----- 1 mysql mysql  1.2K Jul  8 08:20 nagios_eventhandlers.MYD
-rw-r----- 1 mysql mysql   20M Jul  8 08:20 nagios_statehistory.MYI
-rw-r----- 1 mysql mysql   52M Jul  8 08:20 nagios_statehistory.MYD
-rw-r----- 1 mysql mysql  625K Jul  8 08:11 nagios_objects.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:10 nagios_contactstatus.MYI
-rw-r----- 1 mysql mysql  4.0K Jul  8 08:10 nagios_configfilevariables.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_comments.MYI
-rw-r----- 1 mysql mysql  7.0K Jul  8 08:09 nagios_configfilevariables.MYD
-rw-r----- 1 mysql mysql  9.0K Jul  8 08:09 nagios_configfiles.MYI
-rw-r----- 1 mysql mysql    44 Jul  8 08:09 nagios_configfiles.MYD
-rw-r----- 1 mysql mysql   904 Jul  8 08:09 nagios_runtimevariables.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_runtimevariables.MYI
-rw-r----- 1 mysql mysql   19K Jul  8 08:09 nagios_servicegroup_members.MYI
-rw-r----- 1 mysql mysql  8.3K Jul  8 08:09 nagios_servicegroup_members.MYD
-rw-r----- 1 mysql mysql  4.5K Jul  8 08:09 nagios_comments.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_servicegroups.MYI
-rw-r----- 1 mysql mysql   276 Jul  8 08:09 nagios_servicegroups.MYD
-rw-r----- 1 mysql mysql  678K Jul  8 08:09 nagios_objects.MYD
-rw-r----- 1 mysql mysql   37K Jul  8 08:09 nagios_customvariablestatus.MYI
-rw-r----- 1 mysql mysql   38K Jul  8 08:09 nagios_customvariablestatus.MYD
-rw-r----- 1 mysql mysql   34K Jul  8 08:09 nagios_customvariables.MYI
-rw-r----- 1 mysql mysql   37K Jul  8 08:09 nagios_customvariables.MYD
-rw-r----- 1 mysql mysql  7.0K Jul  8 08:09 nagios_service_contacts.MYI
-rw-r----- 1 mysql mysql  1.7K Jul  8 08:09 nagios_service_contacts.MYD
-rw-r----- 1 mysql mysql   78K Jul  8 08:09 nagios_service_contactgroups.MYI
-rw-r----- 1 mysql mysql   41K Jul  8 08:09 nagios_service_contactgroups.MYD
-rw-r----- 1 mysql mysql   48K Jul  8 08:09 nagios_processevents.MYI
-rw-r----- 1 mysql mysql   23K Jul  8 08:09 nagios_services.MYI
-rw-r----- 1 mysql mysql  5.0K Jul  8 08:09 nagios_hostgroup_members.MYI
-rw-r----- 1 mysql mysql  1.2K Jul  8 08:09 nagios_hostgroup_members.MYD
-rw-r----- 1 mysql mysql   304 Jul  8 08:09 nagios_hostgroups.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_hostgroups.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_host_contacts.MYI
-rw-r----- 1 mysql mysql   165 Jul  8 08:09 nagios_host_contacts.MYD
-rw-r----- 1 mysql mysql  9.0K Jul  8 08:09 nagios_host_contactgroups.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_host_contactgroups.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_hosts.MYI
-rw-r----- 1 mysql mysql  5.0K Jul  8 08:09 nagios_contactgroup_members.MYI
-rw-r----- 1 mysql mysql  1.3K Jul  8 08:09 nagios_contactgroup_members.MYD
-rw-r----- 1 mysql mysql  1.8K Jul  8 08:09 nagios_contactstatus.MYD
-rw-r----- 1 mysql mysql   252 Jul  8 08:09 nagios_contactgroups.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_contactgroups.MYI
-rw-r----- 1 mysql mysql  5.0K Jul  8 08:09 nagios_contact_notificationcommands.MYI
-rw-r----- 1 mysql mysql  1.9K Jul  8 08:09 nagios_contact_notificationcommands.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_contact_addresses.MYI
-rw-r----- 1 mysql mysql   900 Jul  8 08:09 nagios_contact_addresses.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_contacts.MYI
-rw-r----- 1 mysql mysql   190 Jul  8 08:09 nagios_timeperiod_exception_timeranges.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_timeperiod_exception_timeranges.MYI
-rw-r----- 1 mysql mysql   350 Jul  8 08:09 nagios_timeperiod_exceptions.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_timeperiod_exceptions.MYI
-rw-r----- 1 mysql mysql   15K Jul  8 08:09 nagios_timeperiod_timeranges.MYI
-rw-r----- 1 mysql mysql  7.5K Jul  8 08:09 nagios_timeperiod_timeranges.MYD
-rw-r----- 1 mysql mysql  2.7K Jul  8 08:09 nagios_timeperiods.MYD
-rw-r----- 1 mysql mysql  3.0K Jul  8 08:09 nagios_timeperiods.MYI
-rw-r----- 1 mysql mysql   19K Jul  8 08:09 nagios_commands.MYD
-rw-r----- 1 mysql mysql  8.0K Jul  8 08:09 nagios_commands.MYI
-rw-r----- 1 mysql mysql  234K Jul  8 08:09 nagios_processevents.MYD
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_timeperiod_exclusions.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_timeperiod_exclusions.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_serviceescalation_contactgroups.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_serviceescalation_contactgroups.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostescalation_contactgroups.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostescalation_contactgroups.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_host_parenthosts.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_service_parentservices.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_service_parentservices.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_host_parenthosts.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_servicedependencies.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostdependencies.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostdependencies.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_servicedependencies.MYD
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_serviceescalation_contacts.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_serviceescalation_contacts.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_serviceescalations.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostescalation_contacts.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostescalation_contacts.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_hostescalations.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_hostescalations.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_serviceescalations.MYD
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_scheduleddowntime.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_scheduleddowntime.MYI
-rw-r----- 1 mysql mysql     0 Jul  8 08:09 nagios_timedeventqueue.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  8 08:09 nagios_timedeventqueue.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_timedevents.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_servicechecks.MYI
-rw-r----- 1 mysql mysql  3.0K Jul  8 07:25 nagios_instances.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_hostchecks.MYI
-rw-r----- 1 mysql mysql  321K Jul  8 07:25 nagios_flappinghistory.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  8 07:25 nagios_externalcommands.MYI
-rw-r----- 1 mysql mysql   91K Jul  8 07:25 nagios_downtimehistory.MYI
-rw-r----- 1 mysql mysql   34K Jul  8 07:25 nagios_conninfo.MYI
-rw-r----- 1 mysql mysql  362K Jul  8 07:25 nagios_commenthistory.MYI
-rw-r----- 1 mysql mysql  351K Jul  8 07:25 nagios_acknowledgements.MYI
-rw-r----- 1 mysql mysql  3.0M Jul  8 02:10 nagios_commenthistory.MYD
-rw-r----- 1 mysql mysql  1.0K Jul  4 17:50 nagios_dbversion.MYI
-rw-r----- 1 mysql mysql  198K Jul  4 17:00 nagios_servicestatus.MYI
-rw-r----- 1 mysql mysql   21K Jul  4 16:58 nagios_hoststatus.MYI
-rw-r----- 1 mysql mysql   13K Jul  4 16:58 nagios_hoststatus.MYD
-rw-r----- 1 mysql mysql   96M Jul  4 16:57 nagios_logentries.MYI
-rw-r----- 1 mysql mysql     0 Jul  4 16:56 nagios_timedevents.MYD
-rw-r----- 1 mysql mysql  279K Jul  4 16:56 nagios_servicestatus.MYD
-rw-r----- 1 mysql mysql  163K Jul  4 16:56 nagios_services.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:56 nagios_servicechecks.MYD
-rw-r----- 1 mysql mysql  2.0K Jul  4 16:56 nagios_regions.MYI
-rw-r----- 1 mysql mysql  1.0K Jul  4 16:56 nagios_rebalance_affected_instances.MYI
-rw-r----- 1 mysql mysql    44 Jul  4 16:56 nagios_regions.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:56 nagios_rebalance_affected_instances.MYD
-rw-r----- 1 mysql mysql  402M Jul  4 16:55 nagios_logentries.MYD
-rw-r----- 1 mysql mysql   108 Jul  4 16:55 nagios_instances.MYD
-rw-r----- 1 mysql mysql   13K Jul  4 16:55 nagios_hosts.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:55 nagios_hostchecks.MYD
-rw-r----- 1 mysql mysql  1.8M Jul  4 16:55 nagios_flappinghistory.MYD
-rw-r----- 1 mysql mysql     0 Jul  4 16:55 nagios_externalcommands.MYD
-rw-r----- 1 mysql mysql  416K Jul  4 16:55 nagios_downtimehistory.MYD
-rw-r----- 1 mysql mysql    20 Jul  4 16:55 nagios_dbversion.MYD
-rw-r----- 1 mysql mysql  4.3K Jul  4 16:55 nagios_contacts.MYD
-rw-r----- 1 mysql mysql  285K Jul  4 16:55 nagios_conninfo.MYD
-rw-r----- 1 mysql mysql 1014K Jul  4 16:55 nagios_acknowledgements.MYD
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_timeperio_4898.sdi
-rw-r----- 1 mysql mysql  6.5K Apr 30 15:13 nagios_timeperio_4897.sdi
-rw-r----- 1 mysql mysql  2.8K Apr 30 15:13 nagios_timeperio_4896.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_timeperio_4895.sdi
-rw-r----- 1 mysql mysql  5.5K Apr 30 15:13 nagios_timeperio_4894.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_timedeven_4893.sdi
-rw-r----- 1 mysql mysql  9.3K Apr 30 15:13 nagios_timedeven_4892.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_systemcom_4891.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_statehist_4890.sdi
-rw-r----- 1 mysql mysql   56K Apr 30 15:13 nagios_servicest_4889.sdi
-rw-r----- 1 mysql mysql   74K Apr 30 15:13 nagios_services_4888.sdi
-rw-r----- 1 mysql mysql   20K Apr 30 15:13 nagios_servicegr_4887.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_servicegr_4886.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_servicees_4885.sdi
-rw-r----- 1 mysql mysql  4.9K Apr 30 15:13 nagios_servicees_4884.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_servicees_4883.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_servicede_4882.sdi
-rw-r----- 1 mysql mysql   29K Apr 30 15:13 nagios_servicech_4881.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_service_p_4880.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_service_c_4879.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_service_c_4878.sdi
-rw-r----- 1 mysql mysql   35K Apr 30 15:13 nagios_scheduled_4877.sdi
-rw-r----- 1 mysql mysql  9.2K Apr 30 15:13 nagios_runtimeva_4876.sdi
-rw-r----- 1 mysql mysql  4.4K Apr 30 15:13 nagios_regions_4875.sdi
-rw-r----- 1 mysql mysql  2.9K Apr 30 15:13 nagios_rebalance_4874.sdi
-rw-r----- 1 mysql mysql   24K Apr 30 15:13 nagios_programst_4873.sdi
-rw-r----- 1 mysql mysql  8.4K Apr 30 15:13 nagios_processev_4872.sdi
-rw-r----- 1 mysql mysql   16K Apr 30 15:13 nagios_objects_4871.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_notificat_4870.sdi
-rw-r----- 1 mysql mysql  9.6K Apr 30 15:13 nagios_logentrie_4869.sdi
-rw-r----- 1 mysql mysql  7.2K Apr 30 15:13 nagios_instances_4868.sdi
-rw-r----- 1 mysql mysql   55K Apr 30 15:13 nagios_hoststatu_4867.sdi
-rw-r----- 1 mysql mysql   89K Apr 30 15:13 nagios_hosts_4866.sdi
-rw-r----- 1 mysql mysql   20K Apr 30 15:13 nagios_hostgroup_4865.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_hostgroup_4864.sdi
-rw-r----- 1 mysql mysql   11K Apr 30 15:13 nagios_hostescal_4863.sdi
-rw-r----- 1 mysql mysql  4.9K Apr 30 15:13 nagios_hostescal_4862.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_hostescal_4861.sdi
-rw-r----- 1 mysql mysql   11K Apr 30 15:13 nagios_hostdepen_4860.sdi
-rw-r----- 1 mysql mysql   29K Apr 30 15:13 nagios_hostcheck_4859.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_host_pare_4858.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_host_cont_4857.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_host_cont_4856.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_flappingh_4855.sdi
-rw-r----- 1 mysql mysql   15K Apr 30 15:13 nagios_externalc_4854.sdi
-rw-r----- 1 mysql mysql   25K Apr 30 15:13 nagios_eventhand_4853.sdi
-rw-r----- 1 mysql mysql   38K Apr 30 15:13 nagios_downtimeh_4852.sdi
-rw-r----- 1 mysql mysql  2.5K Apr 30 15:13 nagios_dbversion_4851.sdi
-rw-r----- 1 mysql mysql   13K Apr 30 15:13 nagios_customvar_4850.sdi
-rw-r----- 1 mysql mysql   12K Apr 30 15:13 nagios_customvar_4849.sdi
-rw-r----- 1 mysql mysql   11K Apr 30 15:13 nagios_contactst_4848.sdi
-rw-r----- 1 mysql mysql   32K Apr 30 15:13 nagios_contacts_4847.sdi
-rw-r----- 1 mysql mysql  8.8K Apr 30 15:13 nagios_contactno_4846.sdi
-rw-r----- 1 mysql mysql   18K Apr 30 15:13 nagios_contactno_4845.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_contactgr_4844.sdi
-rw-r----- 1 mysql mysql  4.8K Apr 30 15:13 nagios_contactgr_4843.sdi
-rw-r----- 1 mysql mysql   15K Apr 30 15:13 nagios_contact_n_4842.sdi
-rw-r----- 1 mysql mysql  6.6K Apr 30 15:13 nagios_contact_a_4841.sdi
-rw-r----- 1 mysql mysql   14K Apr 30 15:13 nagios_conninfo_4840.sdi
-rw-r----- 1 mysql mysql  9.5K Apr 30 15:13 nagios_configfil_4839.sdi
-rw-r----- 1 mysql mysql  5.9K Apr 30 15:13 nagios_configfil_4838.sdi
-rw-r----- 1 mysql mysql   34K Apr 30 15:13 nagios_comments_4837.sdi
-rw-r----- 1 mysql mysql   36K Apr 30 15:13 nagios_commenthi_4836.sdi
-rw-r----- 1 mysql mysql  5.6K Apr 30 15:13 nagios_commands_4835.sdi
-rw-r----- 1 mysql mysql   32K Apr 30 15:13 nagios_acknowled_4834.sdi
Hey @pavan509

So for the archive logs they are log records of the status and events that happen to the monitored services. The reason they can be growing is if you are growing your nagiosxi enviornment or if there is a lot of events (changing of stauts's) on the services being monitored. Like @kg2857 you could check your logrotate settings to clean the files based on a time period that would work for you. Just make sure you are ok with the time periods set for rotating them out incase you needed to look at achieved data.
cnorell
Developer
Posts: 141
Joined: Mon Nov 27, 2017 3:08 pm

Re: Root partition getting occupied with log files and MYD MYI files

Post by cnorell »

pavan509,

For more detail and posterity's sake, here is a link to our document describing the various logs and their use cases in Nagios XI.

Best Regards,

Cory Norell
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Post Reply