Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

shrink db in a nagiosxi database

https://support.nagios.com/forum/viewtopic.php?t=53078

Page 1 of 1

shrink db in a nagiosxi database

Posted: Tue Mar 19, 2019 10:02 am
by dimsum
Hi,

I got a large file in a nagiosxi database. please look at my attached file. is possible to shrink it?

Have you any idea please let me know.

Thank you.

Re: shrink db in a nagiosxi database

Posted: Tue Mar 19, 2019 11:04 am
by npolovenko
Hello, @dimsum. Can you show me the output of the following command?
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table

Re: shrink db in a nagiosxi database

Posted: Tue Mar 19, 2019 11:25 am
by dimsum
here the output.

+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.00 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 0.80 |
| nagios_comments | 0.00 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.03 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 14.72 |
| nagios_contactnotifications | 15.64 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.64 |
| nagios_customvariablestatus | 0.66 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.00 |
| nagios_eventhandlers | 18.08 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 0.33 |
| nagios_host_contactgroups | 0.03 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.07 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.23 |
| nagios_hoststatus | 0.41 |
| nagios_instances | 0.00 |
| nagios_logentries | 13175.18 |
| nagios_notifications | 12378.66 |
| nagios_objects | 1.07 |
| nagios_processevents | 0.06 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.25 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.21 |
| nagios_servicegroups | 0.00 |
| nagios_services | 1.23 |
| nagios_servicestatus | 3.80 |
| nagios_statehistory | 5932.98 |
| nagios_systemcommands | 0.08 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.06 |
| tbl_contact | 0.03 |
| tbl_contactgroup | 0.03 |
| tbl_contacttemplate | 0.03 |
| tbl_domain | 0.03 |
| tbl_host | 0.33 |
| tbl_hostdependency | 0.03 |
| tbl_hostescalation | 0.03 |
| tbl_hostextinfo | 0.03 |
| tbl_hostgroup | 0.03 |
| tbl_hosttemplate | 0.03 |
| tbl_info | 0.17 |
| tbl_lnkContactToCommandHost | 0.02 |
| tbl_lnkContactToCommandService | 0.02 |
| tbl_lnkContactToContactgroup | 0.02 |
| tbl_lnkContactToContacttemplate | 0.02 |
| tbl_lnkContactToVariabledefinition | 0.02 |
| tbl_lnkContactgroupToContact | 0.02 |
| tbl_lnkContactgroupToContactgroup | 0.02 |
| tbl_lnkContacttemplateToCommandHost | 0.02 |
| tbl_lnkContacttemplateToCommandService | 0.02 |
| tbl_lnkContacttemplateToContactgroup | 0.02 |
| tbl_lnkContacttemplateToContacttemplate | 0.02 |
| tbl_lnkContacttemplateToVariabledefinition | 0.02 |
| tbl_lnkHostToContact | 0.02 |
| tbl_lnkHostToContactgroup | 0.05 |
| tbl_lnkHostToHost | 0.02 |
| tbl_lnkHostToHostgroup | 0.02 |
| tbl_lnkHostToHosttemplate | 0.05 |
| tbl_lnkHostToVariabledefinition | 0.05 |
| tbl_lnkHostdependencyToHost_DH | 0.02 |
| tbl_lnkHostdependencyToHost_H | 0.02 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.02 |
| tbl_lnkHostdependencyToHostgroup_H | 0.02 |
| tbl_lnkHostescalationToContact | 0.02 |
| tbl_lnkHostescalationToContactgroup | 0.02 |
| tbl_lnkHostescalationToHost | 0.02 |
| tbl_lnkHostescalationToHostgroup | 0.02 |
| tbl_lnkHostgroupToHost | 0.05 |
| tbl_lnkHostgroupToHostgroup | 0.02 |
| tbl_lnkHosttemplateToContact | 0.02 |
| tbl_lnkHosttemplateToContactgroup | 0.02 |
| tbl_lnkHosttemplateToHost | 0.02 |
| tbl_lnkHosttemplateToHostgroup | 0.02 |
| tbl_lnkHosttemplateToHosttemplate | 0.02 |
| tbl_lnkHosttemplateToVariabledefinition | 0.02 |
| tbl_lnkServiceToContact | 0.02 |
| tbl_lnkServiceToContactgroup | 0.02 |
| tbl_lnkServiceToHost | 0.23 |
| tbl_lnkServiceToHostgroup | 0.02 |
| tbl_lnkServiceToServicegroup | 0.02 |
| tbl_lnkServiceToServicetemplate | 0.27 |
| tbl_lnkServiceToVariabledefinition | 0.25 |
| tbl_lnkServicedependencyToHost_DH | 0.02 |
| tbl_lnkServicedependencyToHost_H | 0.02 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.02 |
| tbl_lnkServicedependencyToHostgroup_H | 0.02 |
| tbl_lnkServicedependencyToService_DS | 0.02 |
| tbl_lnkServicedependencyToService_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.02 |
| tbl_lnkServiceescalationToContactgroup | 0.02 |
| tbl_lnkServiceescalationToHost | 0.02 |
| tbl_lnkServiceescalationToHostgroup | 0.02 |
| tbl_lnkServiceescalationToService | 0.02 |
| tbl_lnkServicegroupToService | 0.22 |
| tbl_lnkServicegroupToServicegroup | 0.02 |
| tbl_lnkServicetemplateToContact | 0.02 |
| tbl_lnkServicetemplateToContactgroup | 0.02 |
| tbl_lnkServicetemplateToHost | 0.02 |
| tbl_lnkServicetemplateToHostgroup | 0.02 |
| tbl_lnkServicetemplateToServicegroup | 0.02 |
| tbl_lnkServicetemplateToServicetemplate | 0.02 |
| tbl_lnkServicetemplateToVariabledefinition | 0.02 |
| tbl_lnkTimeperiodToTimeperiod | 0.02 |
| tbl_logbook | 0.02 |
| tbl_mainmenu | 0.02 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 1.52 |
| tbl_servicedependency | 0.03 |
| tbl_serviceescalation | 0.03 |
| tbl_serviceextinfo | 0.03 |
| tbl_servicegroup | 0.03 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.02 |
| tbl_session_locks | 0.02 |
| tbl_settings | 0.03 |
| tbl_submenu | 0.02 |
| tbl_timedefinition | 0.02 |
| tbl_timeperiod | 0.03 |
| tbl_user | 0.03 |
| tbl_variabledefinition | 0.42 |
| xi_auditlog | 0.64 |
| xi_auth_tokens | 0.03 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.02 |
| xi_eventqueue | 1.03 |
| xi_events | 762.47 |
| xi_incidents | 0.02 |
| xi_meta | 9470.86 |
| xi_options | 0.03 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.03 |
| xi_usermeta | 0.09 |
| xi_users | 0.03 |
+--------------------------------------------+------------+

Thank you.

Re: shrink db in a nagiosxi database

Posted: Tue Mar 19, 2019 12:57 pm
by ssax
NOTE: Take an XI backup/VM snapshot first, just in case:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Yes, you have very large tables:

Code: Select all

| nagios_logentries | 13175.18 |
| nagios_notifications | 12378.66 |
I can't see your entire output but in order to reclaim the space you have two options:

1. If you are running innodb_file_per_table=1 in your /etc/my.cnf or in one of your /etc/my.cnf.d files:

This means that each table uses it's own innodb file, so truncating the individual tables WILL reclaim the space, see the section "In certain instances, it may be necessary to truncate (empty) one or more tables" on page 5 of this PDF:

https://assets.nagios.com/downloads/nag ... tabase.pdf

2. If you are NOT running innodb_file_per_table=1:

*** If you need to go this route, make sure to do it on a test system first as working with the DB is serious business

This means that your entire DB uses the same innodb file, which means that if you truncate a table, the space is NOT reclaimed. In order to reclaim space this way you would need to:

- Truncate the tables following the section from page 5 above

- Stop all of the nagios services

Code: Select all

service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart || service mariadb restart​
- mysqldump the nagiosxi DB:

Code: Select all

mysqldump -h 127.0.0.1 -uroot -pnagiosxi --add-drop-database -B nagiosxi > /tmp/nagiosxidump.sql
- Drop the DB, re-import the data, this will reclaim the space:

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi < /tmp/nagiosxidump.sql
- Start the services back up:

Code: Select all

service ndo2db start
service nagios start
service npcd start
service crond start
service httpd restart
*** NOTE: If you have to do option 2, I would add some additional steps in there to convert your system to use innodb_file_per_table=1.

If you'd like to do that (so that you can truncate in the future without exporting/re-importing to reclaim space, follow the steps for section 3 instead of section 2.

3.

- Truncate the tables following the section from page 5 above

- Stop all of the nagios services

Code: Select all

service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart || service mariadb restart​
- mysqldump all 3 DBs:

Code: Select all

mysqldump -h 127.0.0.1 -uroot -pnagiosxi --add-drop-database -B nagios > /tmp/nagiosdump.sql
mysqldump -h 127.0.0.1 -uroot -pnagiosxi --add-drop-database -B nagiosql > /tmp/nagiosqldump.sql
mysqldump -h 127.0.0.1 -uroot -pnagiosxi --add-drop-database -B nagiosxi > /tmp/nagiosxidump.sql
- Edit your /etc/my.cnf and underneath the [mysqld] section add:

Code: Select all

innodb_file_per_table=1
Then stop mysqld/mariadb, remove the innodb files, start mysqld/mariadb:

Code: Select all

service mysqld stop|| service mariadb stop
rm -f /var/lib/mysql/ibdata1
rm -f /var/lib/mysql/ib_logfile0
rm -f /var/lib/mysql/ib_logfile1
service mysqld start || service mariadb start
- Re-import the data (this will drop the DBs and recreate them with innodb_file_per_table), this will reclaim the space:

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios < /tmp/nagiosdump.sql
mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosql < /tmp/nagiosqldump.sql
mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi < /tmp/nagiosxidump.sql
- Start the services back up:

Code: Select all

service ndo2db start
service nagios start
service npcd start
service crond start
service httpd restart

Re: shrink db in a nagiosxi database

Posted: Mon Mar 25, 2019 9:30 pm
by dimsum
Hi,

I followed step 3 and export/import done. I have a question about CPU time in MySQL service see attached. Is it normal? and I have a lot of hosts and services down because the remote hosts are down, It's an effect on MySQL? If so, can I optimize a database or optimize Nagios configure?

Thank you.

Re: shrink db in a nagiosxi database

Posted: Tue Mar 26, 2019 1:53 pm
by ssax
Please send the fresh output of this command:

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table
And these commands:

Code: Select all

tail -fn100 /var/log/mysqld.log /var/log/messages

Re: shrink db in a nagiosxi database

Posted: Thu Mar 28, 2019 7:31 am
by dimsum
Here the results,

+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.00 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 0.89 |
| nagios_comments | 0.01 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.03 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 18.35 |
| nagios_contactnotifications | 19.65 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.48 |
| nagios_customvariablestatus | 0.53 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.00 |
| nagios_eventhandlers | 0.08 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 0.36 |
| nagios_host_contactgroups | 0.03 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.07 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.21 |
| nagios_hoststatus | 0.38 |
| nagios_instances | 0.00 |
| nagios_logentries | 300.34 |
| nagios_notifications | 25.51 |
| nagios_objects | 1.06 |
| nagios_processevents | 0.06 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.25 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.21 |
| nagios_servicegroups | 0.00 |
| nagios_services | 1.15 |
| nagios_servicestatus | 3.29 |
| nagios_statehistory | 6736.89 |
| nagios_systemcommands | 0.09 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.06 |
| tbl_contact | 0.03 |
| tbl_contactgroup | 0.03 |
| tbl_contacttemplate | 0.03 |
| tbl_domain | 0.03 |
| tbl_host | 0.33 |
| tbl_hostdependency | 0.03 |
| tbl_hostescalation | 0.03 |
| tbl_hostextinfo | 0.03 |
| tbl_hostgroup | 0.03 |
| tbl_hosttemplate | 0.03 |
| tbl_info | 0.17 |
| tbl_lnkContactToCommandHost | 0.02 |
| tbl_lnkContactToCommandService | 0.02 |
| tbl_lnkContactToContactgroup | 0.02 |
| tbl_lnkContactToContacttemplate | 0.02 |
| tbl_lnkContactToVariabledefinition | 0.02 |
| tbl_lnkContactgroupToContact | 0.02 |
| tbl_lnkContactgroupToContactgroup | 0.02 |
| tbl_lnkContacttemplateToCommandHost | 0.02 |
| tbl_lnkContacttemplateToCommandService | 0.02 |
| tbl_lnkContacttemplateToContactgroup | 0.02 |
| tbl_lnkContacttemplateToContacttemplate | 0.02 |
| tbl_lnkContacttemplateToVariabledefinition | 0.02 |
| tbl_lnkHostToContact | 0.02 |
| tbl_lnkHostToContactgroup | 0.05 |
| tbl_lnkHostToHost | 0.02 |
| tbl_lnkHostToHostgroup | 0.02 |
| tbl_lnkHostToHosttemplate | 0.05 |
| tbl_lnkHostToVariabledefinition | 0.05 |
| tbl_lnkHostdependencyToHost_DH | 0.02 |
| tbl_lnkHostdependencyToHost_H | 0.02 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.02 |
| tbl_lnkHostdependencyToHostgroup_H | 0.02 |
| tbl_lnkHostescalationToContact | 0.02 |
| tbl_lnkHostescalationToContactgroup | 0.02 |
| tbl_lnkHostescalationToHost | 0.02 |
| tbl_lnkHostescalationToHostgroup | 0.02 |
| tbl_lnkHostgroupToHost | 0.05 |
| tbl_lnkHostgroupToHostgroup | 0.02 |
| tbl_lnkHosttemplateToContact | 0.02 |
| tbl_lnkHosttemplateToContactgroup | 0.02 |
| tbl_lnkHosttemplateToHost | 0.02 |
| tbl_lnkHosttemplateToHostgroup | 0.02 |
| tbl_lnkHosttemplateToHosttemplate | 0.02 |
| tbl_lnkHosttemplateToVariabledefinition | 0.02 |
| tbl_lnkServiceToContact | 0.02 |
| tbl_lnkServiceToContactgroup | 0.02 |
| tbl_lnkServiceToHost | 0.23 |
| tbl_lnkServiceToHostgroup | 0.02 |
| tbl_lnkServiceToServicegroup | 0.02 |
| tbl_lnkServiceToServicetemplate | 0.27 |
| tbl_lnkServiceToVariabledefinition | 0.23 |
| tbl_lnkServicedependencyToHost_DH | 0.02 |
| tbl_lnkServicedependencyToHost_H | 0.02 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.02 |
| tbl_lnkServicedependencyToHostgroup_H | 0.02 |
| tbl_lnkServicedependencyToService_DS | 0.02 |
| tbl_lnkServicedependencyToService_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.02 |
| tbl_lnkServiceescalationToContactgroup | 0.02 |
| tbl_lnkServiceescalationToHost | 0.02 |
| tbl_lnkServiceescalationToHostgroup | 0.02 |
| tbl_lnkServiceescalationToService | 0.02 |
| tbl_lnkServicegroupToService | 0.22 |
| tbl_lnkServicegroupToServicegroup | 0.02 |
| tbl_lnkServicetemplateToContact | 0.02 |
| tbl_lnkServicetemplateToContactgroup | 0.02 |
| tbl_lnkServicetemplateToHost | 0.02 |
| tbl_lnkServicetemplateToHostgroup | 0.02 |
| tbl_lnkServicetemplateToServicegroup | 0.02 |
| tbl_lnkServicetemplateToServicetemplate | 0.02 |
| tbl_lnkServicetemplateToVariabledefinition | 0.02 |
| tbl_lnkTimeperiodToTimeperiod | 0.02 |
| tbl_logbook | 0.02 |
| tbl_mainmenu | 0.02 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 1.52 |
| tbl_servicedependency | 0.03 |
| tbl_serviceescalation | 0.03 |
| tbl_serviceextinfo | 0.03 |
| tbl_servicegroup | 0.03 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.02 |
| tbl_session_locks | 0.02 |
| tbl_settings | 0.03 |
| tbl_submenu | 0.02 |
| tbl_timedefinition | 0.02 |
| tbl_timeperiod | 0.03 |
| tbl_user | 0.03 |
| tbl_variabledefinition | 0.42 |
| xi_auditlog | 0.86 |
| xi_auth_tokens | 0.03 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.02 |
| xi_eventqueue | 1.03 |
| xi_events | 1481.72 |
| xi_incidents | 0.02 |
| xi_meta | 18808.00 |
| xi_options | 0.03 |
| xi_sessions | 1.53 |
| xi_sysstat | 0.03 |
| xi_usermeta | 0.11 |
| xi_users | 0.03 |
+--------------------------------------------+------------+

For tailf please find the attached file.

Thanks.

Re: shrink db in a nagiosxi database

Posted: Thu Mar 28, 2019 3:43 pm
by ssax
This is why, you're hitting a bug:

Code: Select all

| xi_meta | 18808.00 |
Please run these commands and let us know if the issue is resolved:

If you're running RHEL/CentOS 7+, run these commands:

Code: Select all

systemctl stop crond
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
systemctl restart mysqld || systemctl restart mariadb
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -u root -pnagiosxi nagiosxi
systemctl start ndo2db
systemctl start nagios
systemctl start npcd
systemctl start crond
If you're running RHEL/CentOS 6.X, run these commands instead:

Code: Select all

service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart || service mariadb restart​
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -u root -pnagiosxi nagiosxi
service ndo2db start
service nagios start
service npcd start
service crond start
Then send the fresh output of this command again:

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table
All times are UTC-05:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited