Support for Nagios products and services
https://support.nagios.com/forum/
Code: Select all
/usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -vCode: Select all
/usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -vCode: Select all
echo "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;" |mysql -t -u root -pnagiosxi
mysql -u root -pnagiosxi -e "show global status like '%used_connections%'; show variables like 'max_connections';"Code: Select all
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 136 |
+----------------------+-------+
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |Code: Select all
+--------------------+----------------------------------------------+------------+
| Database | Table | Size in MB |
+--------------------+----------------------------------------------+------------+
| nagios | nagios_commenthistory | 1662.39 |
| nagios | nagios_logentries | 411.95 |
| nagios | nagios_statehistory | 285.11 |
| nagios | nagios_notifications | 103.26 |
| nagios | nagios_downtimehistory | 57.31 |
| nagios | nagios_servicestatus | 5.86 |
| nagios | nagios_objects | 5.10 |
| nagios | nagios_flappinghistory | 4.98 |
| nagios | nagios_contactnotifications | 3.78 |
| nagios | nagios_contactnotificationmethods | 3.58 |
| nagios | nagios_services | 2.49 |
| nagiosxi | xi_meta | 1.84 |
| nagiosxi | xi_usermeta | 1.53 |
| nagiosxi | xi_eventqueue | 1.08 |
| nagiosxi | xi_auditlog | 0.78 |
| nagios | nagios_conninfo | 0.69 |
| nagios | nagios_hoststatus | 0.68 |
| nagios | nagios_processevents | 0.62 |
| nagios | nagios_service_contactgroups | 0.51 |
| nagios | nagios_customvariablestatus | 0.46 |
| mysql | help_topic | 0.45 |
| nagios | nagios_customvariables | 0.44 |
| nagios | nagios_hosts | 0.30 |
| nagiosql | tbl_host | 0.21 |
| nagios | nagios_servicegroup_members | 0.17 |
| nagios | nagios_acknowledgements | 0.16 |
| nagios | nagios_hostgroup_members | 0.15 |
| nagiosql | tbl_service | 0.15 |
| nagiosql | tbl_info | 0.13 |
| mysql | help_keyword | 0.10 |
| nagiosxi | xi_events | 0.09 |
| nagiosql | tbl_permission | 0.08 |
| nagiosql | tbl_variabledefinition | 0.07 |
| nagios | nagios_host_contactgroups | 0.06 |
| nagiosql | tbl_command | 0.05 |
| nagiosql | tbl_lnkHostToHosttemplate | 0.05 |
| nagios | nagios_externalcommands | 0.04 |
| nagiosql | tbl_lnkServiceToHost | 0.04 |
| nagios | nagios_systemcommands | 0.04 |
| nagios | nagios_commands | 0.04 |
| nagiosxi | xi_options | 0.04 |
| nagiosql | tbl_lnkHostToContactgroup | 0.03 |
| nagiosxi | xi_cmp_trapdata_log | 0.03 |
| nagiosxi | xi_cmp_trapdata | 0.03 |
| nagiosxi | xi_auth_tokens | 0.03 |
| nagiosxi | xi_sessions | 0.03 |
| nagios | nagios_contact_notificationcommands | 0.03 |
| mysql | help_relation | 0.03 |
| nagios | nagios_service_contacts | 0.03 |
| nagiosql | tbl_lnkHostgroupToHost | 0.02 |
| nagios | nagios_timeperiod_timeranges | 0.02 |
| nagiosql | tbl_lnkServiceToServicetemplate | 0.02 |
| nagiosql | tbl_servicetemplate | 0.02 |
| nagiosql | tbl_timedefinition | 0.02 |
| nagiosxi | xi_users | 0.02 |
| nagios | nagios_eventhandlers | 0.02 |
| nagiosql | tbl_lnkHostToVariabledefinition | 0.02 |
| nagiosxi | xi_incidents | 0.02 |
| nagiosql | tbl_permission_inactive | 0.02 |
| nagiosql | tbl_lnkServiceToVariabledefinition | 0.02 |
| nagiosql | tbl_hosttemplate | 0.02 |
| nagiosql | tbl_hostgroup | 0.01 |
| nagiosql | tbl_contact | 0.01 |
| nagiosql | tbl_timeperiod | 0.01 |
| nagios | nagios_comments | 0.01 |
| nagios | nagios_configfilevariables | 0.01 |
| nagiosql | tbl_contactgroup | 0.01 |
| nagiosql | tbl_domain | 0.01 |
| nagiosql | tbl_contacttemplate | 0.01 |
| nagiosql | tbl_user | 0.01 |
| nagiosql | tbl_servicedependency | 0.01 |
| nagiosql | tbl_servicegroup | 0.01 |
| nagios | nagios_servicedependencies | 0.01 |
| nagiosql | tbl_lnkServicedependencyToService_DS | 0.01 |
| information_schema | ROUTINES | 0.01 |
| information_schema | EVENTS | 0.01 |
| information_schema | PROCESSLIST | 0.01 |
| information_schema | VIEWS | 0.01 |
| information_schema | PLUGINS | 0.01 |
| information_schema | COLUMNS | 0.01 |
| information_schema | PARTITIONS | 0.01 |
| information_schema | PARAMETERS | 0.01 |
| information_schema | TRIGGERS | 0.01 |
| nagiosxi | xi_sysstat | 0.01 |
| nagios | nagios_contacts | 0.01 |
| mysql | db | 0.01 |
| nagios | nagios_hostgroups | 0.01 |
| nagiosql | tbl_lnkServiceToContactgroup | 0.01 |
| mysql | proxies_priv | 0.01 |
| nagios | nagios_scheduleddowntime | 0.01 |
| nagios | nagios_timeperiods | 0.01 |
| nagiosql | tbl_lnkServicetemplateToServicetemplate | 0.01 |
| nagios | nagios_contactstatus | 0.01 |
| nagios | nagios_configfiles | 0.00 |
| nagiosql | tbl_lnkServiceToHostgroup | 0.00 |
| nagiosql | tbl_lnkHostToHostgroup | 0.00 |
| mysql | proc | 0.00 |
| mysql | help_category | 0.00 |
| nagiosql | tbl_serviceescalation | 0.00 |
| mysql | tables_priv | 0.00 |
| nagiosql | tbl_hostescalation | 0.00 |
| nagiosql | tbl_hostdependency | 0.00 |
| mysql | procs_priv | 0.00 |
| mysql | columns_priv | 0.00 |
| nagios | nagios_contactgroup_members | 0.00 |
| nagios | nagios_runtimevariables | 0.00 |
| nagios | nagios_contactgroups | 0.00 |
| nagiosql | tbl_submenu | 0.00 |
| nagios | nagios_host_contacts | 0.00 |
| nagiosql | tbl_settings | 0.00 |
| nagiosql | tbl_session | 0.00 |
| nagios | nagios_servicegroups | 0.00 |
| nagios | nagios_programstatus | 0.00 |
| nagios | nagios_host_parenthosts | 0.00 |
| nagiosql | tbl_lnkHosttemplateToHosttemplate | 0.00 |
| mysql | user | 0.00 |
| nagiosxi | xi_commands | 0.00 |
| nagiosql | tbl_lnkContactToContacttemplate | 0.00 |
| nagiosql | tbl_lnkServiceToContact | 0.00 |
| nagiosql | tbl_lnkHostToContact | 0.00 |
| nagiosql | tbl_session_locks | 0.00 |
| nagiosql | tbl_lnkHostgroupToHostgroup | 0.00 |
| nagiosql | tbl_lnkServiceToServicegroup | 0.00 |
| nagiosql | tbl_mainmenu | 0.00 |
| nagiosql | tbl_lnkContactgroupToContact | 0.00 |
| nagiosql | tbl_logbook | 0.00 |
| nagiosql | tbl_lnkContactToCommandService | 0.00 |
| nagiosql | tbl_lnkContactToCommandHost | 0.00 |
| nagiosql | tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| nagiosql | tbl_lnkHosttemplateToContactgroup | 0.00 |
| nagiosql | tbl_lnkHostToHost | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHost_H | 0.00 |
| nagiosql | tbl_lnkServicedependencyToService_S | 0.00 |
| nagiosql | tbl_lnkServicegroupToService | 0.00 |
| nagiosql | tbl_lnkHosttemplateToHostgroup | 0.00 |
| nagiosql | tbl_lnkContacttemplateToCommandService | 0.00 |
| nagiosql | tbl_lnkContacttemplateToCommandHost | 0.00 |
| nagios | nagios_instances | 0.00 |
| nagiosql | tbl_lnkServicetemplateToHostgroup | 0.00 |
| nagiosql | tbl_lnkServicetemplateToHost | 0.00 |
| nagiosql | tbl_lnkContacttemplateToContactgroup | 0.00 |
| mysql | host | 0.00 |
| mysql | event | 0.00 |
| nagios | nagios_dbversion | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| mysql | ndb_binlog_index | 0.00 |
| nagiosql | tbl_lnkServicegroupToServicegroup | 0.00 |
| nagiosql | tbl_lnkServiceescalationToService | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| nagiosql | tbl_serviceextinfo | 0.00 |
| nagiosql | tbl_lnkServiceescalationToHostgroup | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHost_H | 0.00 |
| nagiosql | tbl_lnkServiceescalationToHost | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHost_DH | 0.00 |
| nagios | nagios_contact_addresses | 0.00 |
| nagiosql | tbl_lnkServiceescalationToContactgroup | 0.00 |
| mysql | time_zone_transition | 0.00 |
| nagiosql | tbl_lnkServiceescalationToContact | 0.00 |
| nagiosql | tbl_hostextinfo | 0.00 |
| nagios | nagios_timedevents | 0.00 |
| mysql | time_zone_name | 0.00 |
| nagios | nagios_timedeventqueue | 0.00 |
| mysql | time_zone_leap_second | 0.00 |
| nagiosql | tbl_lnkHosttemplateToHost | 0.00 |
| mysql | time_zone | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| nagiosql | tbl_lnkTimeperiodToTimeperiod | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| nagiosql | tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| nagios | nagios_serviceescalations | 0.00 |
| nagiosql | tbl_lnkHosttemplateToContact | 0.00 |
| mysql | func | 0.00 |
| nagiosql | tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| nagios | nagios_serviceescalation_contacts | 0.00 |
| nagiosql | tbl_lnkContactgroupToContactgroup | 0.00 |
| mysql | servers | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHost_DH | 0.00 |
| nagiosql | tbl_lnkServicetemplateToServicegroup | 0.00 |
| nagiosql | tbl_lnkContacttemplateToContacttemplate | 0.00 |
| nagios | nagios_serviceescalation_contactgroups | 0.00 |
| nagios | nagios_hostchecks | 0.00 |
| nagios | nagios_hostescalations | 0.00 |
| nagios | nagios_servicechecks | 0.00 |
| nagiosql | tbl_lnkHostescalationToHostgroup | 0.00 |
| nagios | nagios_hostescalation_contacts | 0.00 |
| nagiosql | tbl_lnkContactToVariabledefinition | 0.00 |
| mysql | time_zone_transition_type | 0.00 |
| nagios | nagios_service_parentservices | 0.00 |
| nagiosql | tbl_lnkHostescalationToContactgroup | 0.00 |
| nagiosql | tbl_lnkHostescalationToHost | 0.00 |
| nagios | nagios_hostescalation_contactgroups | 0.00 |
| nagiosql | tbl_lnkServicetemplateToContactgroup | 0.00 |
| nagiosql | tbl_lnkHostescalationToContact | 0.00 |
| nagios | nagios_hostdependencies | 0.00 |
| nagiosql | tbl_lnkContactToContactgroup | 0.00 |
| mysql | plugin | 0.00 |
| nagiosql | tbl_lnkServicetemplateToContact | 0.00 |
| performance_schema | file_summary_by_instance | 0.00 |
| information_schema | INNODB_BUFFER_PAGE_LRU | 0.00 |
| information_schema | TABLES | 0.00 |
| information_schema | INNODB_SYS_FIELDS | 0.00 |
| performance_schema | file_summary_by_event_name | 0.00 |
| information_schema | KEY_COLUMN_USAGE | 0.00 |
| information_schema | INNODB_SYS_FOREIGN_COLS | 0.00 |
| information_schema | STATISTICS | 0.00 |
| information_schema | INNODB_SYS_TABLES | 0.00 |
| information_schema | KEY_CACHES | 0.00 |
| information_schema | INNODB_TABLE_STATS | 0.00 |
| information_schema | SESSION_VARIABLES | 0.00 |
| information_schema | INNODB_BUFFER_POOL_PAGES_BLOB | 0.00 |
| information_schema | INNODB_INDEX_STATS | 0.00 |
| performance_schema | file_instances | 0.00 |
| information_schema | XTRADB_ADMIN_COMMAND | 0.00 |
| information_schema | SESSION_STATUS | 0.00 |
| information_schema | INNODB_LOCKS | 0.00 |
| information_schema | INNODB_LOCK_WAITS | 0.00 |
| performance_schema | events_waits_summary_global_by_event_name | 0.00 |
| information_schema | INDEX_STATISTICS | 0.00 |
| information_schema | SCHEMA_PRIVILEGES | 0.00 |
| information_schema | INNODB_BUFFER_POOL_PAGES_INDEX | 0.00 |
| information_schema | INNODB_SYS_TABLESTATS | 0.00 |
| performance_schema | events_waits_summary_by_thread_by_event_name | 0.00 |
| information_schema | GLOBAL_VARIABLES | 0.00 |
| information_schema | SCHEMATA | 0.00 |
| information_schema | INNODB_TRX | 0.00 |
| information_schema | INNODB_CMPMEM | 0.00 |
| performance_schema | events_waits_summary_by_instance | 0.00 |
| information_schema | GLOBAL_STATUS | 0.00 |
| information_schema | INNODB_BUFFER_POOL_PAGES | 0.00 |
| information_schema | INNODB_UNDO_LOGS | 0.00 |
| performance_schema | events_waits_history_long | 0.00 |
| information_schema | FILES | 0.00 |
| information_schema | INNODB_RSEG | 0.00 |
| performance_schema | events_waits_history | 0.00 |
| information_schema | REFERENTIAL_CONSTRAINTS | 0.00 |
| information_schema | INNODB_CHANGED_PAGES | 0.00 |
| information_schema | INNODB_CMPMEM_RESET | 0.00 |
| performance_schema | events_waits_current | 0.00 |
| information_schema | ENGINES | 0.00 |
| information_schema | PROFILING | 0.00 |
| information_schema | INNODB_CMP_RESET | 0.00 |
| information_schema | COLUMN_PRIVILEGES | 0.00 |
| mysql | general_log | 0.00 |
| information_schema | INNODB_CMP | 0.00 |
| performance_schema | cond_instances | 0.00 |
| performance_schema | threads | 0.00 |
| mysql | slow_log | 0.00 |
| information_schema | USER_STATISTICS | 0.00 |
| performance_schema | setup_timers | 0.00 |
| information_schema | USER_PRIVILEGES | 0.00 |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | 0.00 |
| information_schema | INNODB_SYS_INDEXES | 0.00 |
| information_schema | COLLATIONS | 0.00 |
| performance_schema | setup_consumers | 0.00 |
| performance_schema | setup_instruments | 0.00 |
| information_schema | INNODB_SYS_FOREIGN | 0.00 |
| information_schema | TABLE_STATISTICS | 0.00 |
| information_schema | CLIENT_STATISTICS | 0.00 |
| performance_schema | rwlock_instances | 0.00 |
| information_schema | INNODB_SYS_STATS | 0.00 |
| information_schema | TABLE_PRIVILEGES | 0.00 |
| information_schema | CHARACTER_SETS | 0.00 |
| performance_schema | performance_timers | 0.00 |
| information_schema | INNODB_BUFFER_PAGE | 0.00 |
| information_schema | INNODB_SYS_COLUMNS | 0.00 |
| information_schema | TABLE_CONSTRAINTS | 0.00 |
| performance_schema | mutex_instances | 0.00 |
| information_schema | INNODB_BUFFER_POOL_STATS | 0.00 |
| information_schema | TABLESPACES | 0.00 |
+--------------------+----------------------------------------------+------------+Code: Select all
/var/log/messages
/var/log/mysqld.log
/var/log/mariadb/mariadb.log
/var/log/httpd/error_log
/var/log/httpd/ssl_error_log