We are suffering serious problems when we try to insert data into database using NDO2DB. we have been working with our IT deparment trying to find the problem, and we didn't detect the root cause of it, the server health is good, they didn't find problems with CPU, memory or hard disk use.
Some background info. We have three servers running, let's call them NEW, OLD and INT. NEW is the final production server, INT is a development server to test new features before moving them to PROD and OLD is a deprecated server that has some assets configured and we are migrate them to PROD. A month ago all of them had installed 5.6.7 Nagios version. PROD and INT had in the past an offloaded database, but due to some performance problems we moved those offloaded databases back to local.
NEW
* 32 CPU
* 128 GB RAM
* Hosts (configured/active): 3702/3233
* Services (configured/active): 11040/4863
* Red Hat Enterprise Linux Server release 7.9 (Maipo)
OLD
* 32 CPU
* 128 GB RAM
* Hosts (configured/active): 3546/3483
* Services (configured/active): 19878/18757
* Red Hat Enterprise Linux Server release 7.9 (Maipo)
INT
* 8CPU
* 32 GB RAM
* Hosts (configured/active): 137/135
* Services (configured/active): 540/511
* Red Hat Enterprise Linux Server release 7.9 (Maipo)
Due to some vulnerabilities, IT "recomended" us to update the Nagios application to its lastest version (5.8.7 is the current one now). None of the servers have internet access, even the installations are a normal ones (not offline installation), we requested temporary access to some repos for the update process. We reviewed the release notes and realized that NDO3 will bring us performance improvements, so good news... We tested the process in INT and once we confirmed that everything was working well after the update, we update NEW.
The first thing we observed after the update was that NDOUtils was not updated as you can see here: https://support.nagios.com/forum/viewto ... 16&t=64675 it was a weird situation, because based on the query result, NDOUtils should be updated and it wasn't.
We opened in the past some support tickets regarding a similar problem: https://support.nagios.com/tickets/tickets.php?id=13867 that was related to https://support.nagios.com/forum/viewto ... 16&t=62222 .We need historical info at least for the last 6 months, so we can't truncate or reduce those tables size/retention period. We didn't generate ramdisk because the OLD server is able to handle more checks than NEW.
Other posts:
- An entry for DB (offloaded) performance problems, asking if there was a way to avoid inserting customvariables status to minimize the insertion process into database: https://support.nagios.com/forum/viewto ... 16&t=63001
- This entry was about a problem related with DB access problems in an offloaded DB so based on that and in another posts we moved the DB back to local: https://support.nagios.com/forum/viewto ... 16&t=59556
- A Delay between last update and last check is directly related with the data insertion in Nagios DB using ndo2db (the one that is linked to the support ticket): https://support.nagios.com/forum/viewto ... 16&t=62222
In the forum we found a performance problem using ND3 so I'm a bit worryied about updating manually ndoutils from 2.1.2 to 3.0.7:
[*] XI: NDO3 -- instability / poor performance at scale: https://support.nagios.com/forum/viewto ... 16&t=62007
IPCS queues
INT
Code: Select all
# ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
#
Code: Select all
# ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0x91000040 6 nagios 600 796285952 777623
#
Code: Select all
]# ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0x99000040 5 nagios 600 0 0
#
NEW
Code: Select all
# cat /etc/sysctl.conf | grep kernel
kernel.randomize_va_space = 2
kernel.msgmnb = 796432000
kernel.msgmax = 796432000
kernel.shmmax = 4294967295
kernel.shmall = 268435456
Code: Select all
# cat /etc/sysctl.conf | grep kernel
kernel.randomize_va_space = 2
kernel.msgmnb = 796432000
kernel.msgmax = 796432000
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.msgmni = 32768 <- This is the maximum value allowed for RHEL: https://access.redhat.com/solutions/4968021
Code: Select all
# cat /etc/sysctl.conf | grep kernel
kernel.randomize_va_space = 2
kernel.msgmnb = 796432000
kernel.msgmax = 796432000
kernel.shmmax = 4294967295
kernel.shmall = 268435456
#
sar
Code: Select all
Linux 3.10.0-1160.53.1.el7.x86_64 (PRODNAA002X) 03/09/2022 _x86_64_ (32 CPU)
12:00:01 AM CPU %user %nice %system %iowait %steal %idle
12:10:01 AM all 2.62 0.00 1.68 1.84 0.00 93.86
12:20:01 AM all 2.59 0.00 1.67 1.37 0.00 94.38
12:30:01 AM all 2.67 0.00 1.73 1.46 0.00 94.15
12:40:01 AM all 2.90 0.00 1.85 1.42 0.00 93.83
12:50:01 AM all 2.53 0.00 1.64 1.16 0.00 94.66
01:00:01 AM all 2.53 0.00 1.66 1.22 0.00 94.60
01:10:01 AM all 2.64 0.00 1.74 1.95 0.00 93.67
01:20:01 AM all 2.55 0.00 1.65 2.08 0.00 93.72
01:30:01 AM all 2.51 0.00 1.65 1.45 0.00 94.39
01:40:01 AM all 2.83 0.00 1.83 1.72 0.00 93.62
01:50:01 AM all 2.52 0.00 1.67 1.16 0.00 94.65
02:00:01 AM all 2.45 0.00 1.64 1.07 0.00 94.85
02:10:01 AM all 3.22 0.00 2.24 1.51 0.00 93.03
02:20:01 AM all 3.17 0.00 1.90 1.41 0.00 93.53
02:30:01 AM all 2.77 0.00 1.76 1.28 0.00 94.19
02:40:01 AM all 2.74 0.00 1.77 1.68 0.00 93.82
02:50:01 AM all 2.76 0.00 1.77 1.25 0.00 94.21
03:00:01 AM all 2.47 0.00 1.64 1.25 0.00 94.64
03:10:01 AM all 2.50 0.00 1.67 1.61 0.00 94.22
03:20:01 AM all 2.46 0.00 1.64 1.36 0.00 94.54
03:30:01 AM all 2.50 0.00 1.64 1.26 0.00 94.60
03:40:01 AM all 2.56 0.00 1.77 1.51 0.00 94.16
03:50:01 AM all 2.98 0.03 1.87 1.36 0.00 93.76
04:00:01 AM all 2.47 0.00 1.63 1.41 0.00 94.50
04:10:01 AM all 2.54 0.00 1.70 1.81 0.00 93.95
04:20:01 AM all 2.47 0.00 1.65 1.55 0.00 94.33
04:30:01 AM all 2.60 0.00 1.68 1.76 0.00 93.96
04:40:01 AM all 2.51 0.00 1.65 2.58 0.00 93.26
04:50:01 AM all 2.72 0.00 1.74 2.45 0.00 93.09
05:00:01 AM all 2.70 0.00 1.72 2.53 0.00 93.04
05:10:01 AM all 2.97 0.00 2.08 2.75 0.00 92.20
05:20:01 AM all 2.46 0.00 1.67 2.84 0.00 93.03
05:30:01 AM all 2.50 0.00 1.66 2.77 0.00 93.08
05:40:01 AM all 2.38 0.00 1.60 2.98 0.00 93.05
05:50:01 AM all 2.40 0.00 1.61 2.90 0.00 93.09
06:00:01 AM all 2.84 0.00 1.82 2.84 0.00 92.49
06:10:01 AM all 2.33 0.00 1.58 3.08 0.00 93.00
06:20:01 AM all 2.40 0.00 1.62 2.90 0.00 93.08
06:30:01 AM all 2.92 0.00 2.08 2.92 0.00 92.08
06:40:01 AM all 3.15 0.00 1.88 2.94 0.00 92.04
06:50:01 AM all 2.85 0.00 1.79 2.88 0.00 92.48
07:00:01 AM all 2.97 0.00 1.80 2.84 0.00 92.39
07:10:01 AM all 3.83 0.00 1.85 2.71 0.00 91.61
07:20:01 AM all 2.85 0.00 1.68 3.27 0.00 92.20
07:30:01 AM all 3.01 0.00 1.80 2.41 0.00 92.77
07:40:01 AM all 3.03 0.00 1.79 2.50 0.00 92.68
07:50:01 AM all 2.66 0.00 1.55 2.40 0.00 93.39
08:00:01 AM all 1.81 0.00 1.18 2.41 0.00 94.60
08:10:01 AM all 1.16 0.00 0.56 2.59 0.00 95.69
08:20:01 AM all 0.93 0.00 0.38 2.50 0.00 96.19
08:20:01 AM CPU %user %nice %system %iowait %steal %idle
08:30:01 AM all 3.04 0.00 2.22 2.84 0.00 91.90
08:40:01 AM all 2.63 0.00 1.74 3.03 0.00 92.59
08:50:01 AM all 2.54 0.00 1.68 2.93 0.00 92.85
09:00:01 AM all 2.54 0.00 1.66 3.00 0.00 92.79
09:10:01 AM all 2.56 0.00 1.70 2.94 0.00 92.81
09:20:01 AM all 2.80 0.00 1.83 2.87 0.00 92.50
09:30:01 AM all 2.92 0.00 1.91 2.89 0.00 92.29
09:40:01 AM all 2.73 0.00 1.81 2.91 0.00 92.55
09:50:01 AM all 2.67 0.00 1.75 2.94 0.00 92.64
10:00:01 AM all 2.62 0.00 1.72 2.92 0.00 92.74
10:10:01 AM all 2.59 0.00 1.70 3.06 0.00 92.64
10:20:01 AM all 2.65 0.00 1.71 2.97 0.00 92.67
10:30:01 AM all 2.99 0.00 1.85 2.89 0.00 92.27
10:40:01 AM all 3.02 0.00 1.89 2.87 0.00 92.21
10:50:01 AM all 2.79 0.00 1.73 2.89 0.00 92.59
11:00:01 AM all 2.77 0.00 1.78 2.94 0.00 92.51
11:10:01 AM all 2.79 0.00 1.73 2.93 0.00 92.55
11:20:01 AM all 2.69 0.00 1.86 2.82 0.00 92.63
11:30:01 AM all 2.80 0.00 1.87 2.86 0.00 92.46
11:40:01 AM all 2.59 0.00 1.79 2.88 0.00 92.73
11:50:01 AM all 2.69 0.00 1.81 2.87 0.00 92.64
Average: all 2.65 0.00 1.71 2.31 0.00 93.32
Code: Select all
Linux 3.10.0-1160.53.1.el7.x86_64 (PRODNAA002X) 03/09/2022 _x86_64_ (32 CPU)
11:52:54 AM CPU %user %nice %system %iowait %steal %idle
11:52:57 AM all 0.20 0.00 0.17 2.91 0.00 96.73
11:53:00 AM all 0.36 0.00 0.17 2.91 0.00 96.56
11:53:03 AM all 2.67 0.00 1.64 2.43 0.00 93.26
11:53:06 AM all 9.42 0.00 6.65 2.41 0.00 81.52
11:53:09 AM all 42.36 0.00 22.92 1.56 0.00 33.15
11:53:12 AM all 16.29 0.00 24.29 2.22 0.00 57.20
11:53:15 AM all 1.23 0.00 0.97 3.06 0.00 94.74
11:53:18 AM all 0.29 0.00 0.47 3.06 0.00 96.18
Average: all 8.97 0.00 7.08 2.57 0.00 81.37
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');
- # Table, Size in MB
'SAIM_comments_view_backup', NULL --> Custom views for external integration
'SAIM_old_API_Values_view_backup', NULL --> Custom views for external integration
'SAIM_old_view', NULL --> Custom views for external integration
'SAIM_view', NULL --> Custom views for external integration
- 'SAIM_comments_view_backup', NULL --> Custom views for external integration
'SAIM_old_API_Values_view_backup', NULL --> Custom views for external integration
'SAIM_old_view', NULL --> Custom views for external integration
'SAIM_view', NULL --> Custom views for external integration
- 'nagios_acknowledgements', '0.39'
'nagios_commands', '0.08'
'nagios_commenthistory', '49.08'
'nagios_comments', '1.67'
'nagios_configfiles', '0.03'
'nagios_configfilevariables', '0.02'
'nagios_conninfo', '0.36'
'nagios_contact_addresses', '0.03'
'nagios_contact_notificationcommands', '0.14'
'nagios_contactgroup_members', '0.03'
'nagios_contactgroups', '0.03'
'nagios_contactnotificationmethods', '280.92'
'nagios_contactnotifications', '333.52'
'nagios_contacts', '0.06'
'nagios_contactstatus', '0.03'
'nagios_customvariables', '6.55'
'nagios_customvariablestatus', '5.55'
'nagios_dbversion', '0.02'
'nagios_downtimehistory', '0.03'
'nagios_eventhandlers', '1.59'
'nagios_externalcommands', '0.05'
'nagios_flappinghistory', '23.55'
'nagios_host_contactgroups', '0.45'
'nagios_host_contacts', '0.03'
'nagios_host_parenthosts', '0.03'
'nagios_hostchecks', '0.03'
'nagios_hostdependencies', '0.03'
'nagios_hostescalation_contactgroups', '0.03'
'nagios_hostescalation_contacts', '0.03'
'nagios_hostescalations', '0.03'
'nagios_hostgroup_members', '3.03'
'nagios_hostgroups', '0.09'
'nagios_hosts', '1.77'
'nagios_hoststatus', '2.80'
'nagios_instances', '0.02'
'nagios_logentries', '3564.70'
'nagios_notifications', '774.03'
'nagios_objects', '5.16'
'nagios_processevents', '0.47'
'nagios_programstatus', '0.03'
'nagios_runtimevariables', '0.03'
'nagios_scheduleddowntime', '0.03'
'nagios_service_contactgroups', '0.52'
'nagios_service_contacts', '0.03'
'nagios_service_parentservices', '0.03'
'nagios_servicechecks', '0.06'
'nagios_servicedependencies', '0.03'
'nagios_serviceescalation_contactgroups', '0.03'
'nagios_serviceescalation_contacts', '0.03'
'nagios_serviceescalations', '0.03'
'nagios_servicegroup_members', '0.16'
'nagios_servicegroups', '0.03'
'nagios_services', '1.84'
'nagios_servicestatus', '4.31'
'nagios_statehistory', '1617.59'
'nagios_systemcommands', '0.47'
'nagios_timedeventqueue', '0.09'
'nagios_timedevents', '0.09'
'nagios_timeperiod_timeranges', '0.11'
'nagios_timeperiods', '0.03'
- 'tbl_command', '0.08'
'tbl_contact', '0.06'
'tbl_contactgroup', '0.03'
'tbl_contacttemplate', '0.03'
'tbl_domain', '0.03'
'tbl_host', '1.66'
'tbl_hostdependency', '0.03'
'tbl_hostescalation', '0.03'
'tbl_hostextinfo', '0.03'
'tbl_hostgroup', '0.14'
'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.23'
'tbl_lnkHostToHost', '0.02'
'tbl_lnkHostToHostgroup', '1.52'
'tbl_lnkHostToHosttemplate', '0.27'
'tbl_lnkHostToVariabledefinition', '1.52'
'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.06'
'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.22'
'tbl_lnkServiceToHost', '0.34'
'tbl_lnkServiceToHostgroup', '0.02'
'tbl_lnkServiceToServicegroup', '0.23'
'tbl_lnkServiceToServicetemplate', '1.52'
'tbl_lnkServiceToVariabledefinition', '1.52'
'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_lnkServicedependencyToServicegroup_DS', '0.02'
'tbl_lnkServicedependencyToServicegroup_S', '0.02'
'tbl_lnkServiceescalationToContact', '0.02'
'tbl_lnkServiceescalationToContactgroup', '0.02'
'tbl_lnkServiceescalationToHost', '0.02'
'tbl_lnkServiceescalationToHostgroup', '0.02'
'tbl_lnkServiceescalationToService', '0.02'
'tbl_lnkServiceescalationToServicegroup', '0.02'
'tbl_lnkServicegroupToService', '0.02'
'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.06'
'tbl_session', '0.02'
'tbl_session_locks', '0.02'
'tbl_settings', '0.03'
'tbl_submenu', '0.02'
'tbl_timedefinition', '0.08'
'tbl_timeperiod', '0.03'
'tbl_user', '0.03'
'tbl_variabledefinition', '3.52'
- 'xi_auditlog', '8.33'
'xi_auth_tokens', '0.03'
'xi_cmp_ccm_backups', '0.02'
'xi_cmp_favorites', '0.03'
'xi_cmp_nagiosbpi_backups', '0.02'
'xi_cmp_scheduledreports_log', '0.02'
'xi_cmp_trapdata', '0.03'
'xi_cmp_trapdata_log', '0.03'
'xi_commands', '0.02'
'xi_deploy_agents', '0.02'
'xi_deploy_jobs', '0.02'
'xi_eventqueue', '0.03'
'xi_events', '2.16'
'xi_meta', '21.55'
'xi_mibs', '0.05'
'xi_options', '0.06'
'xi_sessions', '0.03'
'xi_sysstat', '0.03'
'xi_usermeta', '2.94'
'xi_users', '0.08'
Code: Select all
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
net.ipv6.conf.default.accept_ra = 0
net.ipv6.conf.default.accept_redirects = 0
net.ipv6.conf.all.accept_ra = 0
net.ipv6.conf.all.accept_redirects = 0
net.ipv6.conf.lo.accept_ra = 0
net.ipv6.conf.lo.accept_redirects = 0
net.ipv4.ip_forward = 0
net.ipv4.route.flush = 1
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.default.send_redirects = 0
net.ipv4.route.flush = 1
net.ipv4.conf.all.accept_source_route = 0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.route.flush = 1
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.default.send_redirects = 0
net.ipv4.route.flush = 1
net.ipv4.conf.all.accept_redirects = 0
net.ipv4.conf.default.accept_redirects = 0
net.ipv4.conf.all.secure_redirects = 0
net.ipv4.conf.default.secure_redirects = 0
net.ipv4.conf.all.log_martians = 1
net.ipv4.conf.default.log_martians = 1
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.icmp_ignore_bogus_error_responses = 1
net.ipv4.conf.all.rp_filter = 1
net.ipv4.conf.default.rp_filter = 1
net.ipv4.tcp_syncookies = 1
net.ipv6.conf.all.accept_redirects = 0
net.ipv6.conf.default.accept_redirects = 0
net.ipv6.route.flush = 1
fs.suid_dumpable = 0
kernel.randomize_va_space = 2
net.ipv4.icmp_ignore_bogus_error_responses = 1
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.log_martians = 1
net.ipv4.conf.default.log_martians = 1
kernel.msgmnb = 796432000
kernel.msgmax = 796432000
kernel.shmmax = 4294967295
kernel.shmall = 268435456
Code: Select all
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 514928
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 10000
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 514928
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Code: Select all
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 514928
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 10000
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 4096
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Code: Select all
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 514928
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 10000
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 4096
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Code: Select all
/etc/my.cnf:max_connections=2048
Code: Select all
+----------+
| count(*) |
+----------+
| 19027 |
+----------+
Code: Select all
# Id, User, Host, db, Command, Time, State, Info, Progress
'106699', 'root', 'jumphost:12511', NULL, 'Sleep', '212', '', NULL, '0.000'
'106700', 'root', 'jumphost:12512', 'nagios', 'Query', '0', NULL, 'show full processlist', '0.000'
'113151', 'ndoutils', 'localhost', 'nagios', 'Sleep', '12935', '', NULL, '0.000'
'113152', 'ndoutils', 'localhost', 'nagios', 'Query', '0', 'query end', 'INSERT INTO nagios_hoststatus SET instance_id=\'1\', host_object_id=\'14512\', status_update_time=FROM_UNIXTIME(1646817300), output=\'OK - 10\\.22\\.201\\.76 rta 298\\.978ms lost 0%\', long_output=\'\', perfdata=\'rta=298\\.978ms;3000\\.000;5000\\.000;0; pl=0%;80;100;0;100 rtmax=307\\.551ms;;;; rtmin=290\\.607ms;;;;\', current_state=\'0\', has_been_checked=\'1\', should_be_scheduled=\'1\', current_check_attempt=\'1\', max_check_attempts=\'5\', last_check=FROM_UNIXTIME(1646817300), next_check=FROM_UNIXTIME(1646817600), check_type=\'0\', last_state_change=FROM_UNIXTIME(1646733190), last_hard_state_change=FROM_UNIXTIME(1646733190), last_hard_state=\'0\', last_time_up=FROM_UNIXTIME(1646817300), last_time_down=FROM_UNIXTIME(1646732229), last_time_unreachable=FROM_UNIXTIME(0), state_type=\'1\', last_notification=FROM_UNIXTIME(1646733192), next_notification=FROM_UNIXTIME(0), no_more_notifications=\'0\', notifications_enabled=\'1\', problem_has_been_acknowledged=\'0\', acknowledgement_type=\'0\', current_notification_number=\'0\', passive_checks_enabled=\'1\', active_checks_enabled=\'1\', event_handler_enabled=\'1\', flap_detection_enabled=\'1\', is_flapping=\'0\', percent_state_change=\'0.000000\', latency=\'0.000000\', execution_time=\'0.683250\', scheduled_downtime_depth=\'0\', failure_prediction_enabled=\'0\', process_performance_data=\'1\', obsess_over_host=\'1\', modified_host_attributes=\'0\', event_handler=\'\', check_command=\'check-host-alive!!!!!!!!\', normal_check_interval=\'5.000000\', retry_check_interval=\'1.000000\', check_timeperiod_object_id=\'157\' ON DUPLICATE KEY UPDATE instance_id=\'1\', host_object_id=\'14512\', status_update_time=FROM_UNIXTIME(1646817300), output=\'OK - 10\\.22\\.201\\.76 rta 298\\.978ms lost 0%\', long_output=\'\', perfdata=\'rta=298\\.978ms;3000\\.000;5000\\.000;0; pl=0%;80;100;0;100 rtmax=307\\.551ms;;;; rtmin=290\\.607ms;;;;\', current_state=\'0\', has_been_checked=\'1\', should_be_scheduled=\'1\', current_check_attempt=\'1\', max_check_attempts=\'5\', last_check=FROM_UNIXTIME(1646817300), next_check=FROM_UNIXTIME(1646817600), check_type=\'0\', last_state_change=FROM_UNIXTIME(1646733190), last_hard_state_change=FROM_UNIXTIME(1646733190), last_hard_state=\'0\', last_time_up=FROM_UNIXTIME(1646817300), last_time_down=FROM_UNIXTIME(1646732229), last_time_unreachable=FROM_UNIXTIME(0), state_type=\'1\', last_notification=FROM_UNIXTIME(1646733192), next_notification=FROM_UNIXTIME(0), no_more_notifications=\'0\', notifications_enabled=\'1\', problem_has_been_acknowledged=\'0\', acknowledgement_type=\'0\', current_notification_number=\'0\', passive_checks_enabled=\'1\', active_checks_enabled=\'1\', event_handler_enabled=\'1\', flap_detection_enabled=\'1\', is_flapping=\'0\', percent_state_change=\'0.000000\', latency=\'0.000000\', execution_time=\'0.683250\', scheduled_downtime_depth=\'0\', failure_prediction_enabled=\'0\', process_performance_data=\'1\', obsess_over_host=\'1\', modified_host_attributes=\'0\', event_handler=\'\', check_command=\'check-host-alive!!!!!!!!\', normal_check_interval=\'5.000000\', retry_check_interval=\'1.000000\', check_timeperiod_object_id=\'157\'', '0.000'
'137271', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '6', '', NULL, '0.000'
'137272', 'ndoutils', 'localhost', 'nagios', 'Sleep', '6', '', NULL, '0.000'
'137273', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '6', '', NULL, '0.000'
'137477', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '29', '', NULL, '0.000'
'137478', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '14', '', NULL, '0.000'
'137479', 'ndoutils', 'localhost', 'nagios', 'Sleep', '14', '', NULL, '0.000'
'137480', 'ndoutils', 'localhost', 'nagios', 'Sleep', '29', '', NULL, '0.000'
'137481', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '29', '', NULL, '0.000'
'137482', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '14', '', NULL, '0.000'
'137484', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '2', '', NULL, '0.000'
'137486', 'ndoutils', 'localhost', 'nagios', 'Sleep', '2', '', NULL, '0.000'
'137488', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '2', '', NULL, '0.000'
'137502', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '12', '', NULL, '0.000'
'137504', 'ndoutils', 'localhost', 'nagios', 'Sleep', '12', '', NULL, '0.000'
'137506', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '12', '', NULL, '0.000'
'137507', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '16', '', NULL, '0.000'
'137508', 'ndoutils', 'localhost', 'nagios', 'Sleep', '16', '', NULL, '0.000'
'137509', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '16', '', NULL, '0.000'
'137582', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '1', '', NULL, '0.000'
'137583', 'ndoutils', 'localhost', 'nagios', 'Sleep', '1', '', NULL, '0.000'
'137584', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '1', '', NULL, '0.000'
'137587', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '0', '', NULL, '0.000'
'137588', 'ndoutils', 'localhost', 'nagios', 'Sleep', '1', '', NULL, '0.000'
'137589', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '1', '', NULL, '0.000'
'137606', 'root', 'localhost', 'nagios', 'Sleep', '31', '', NULL, '0.000'
'137610', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '1', '', NULL, '0.000'
'137613', 'ndoutils', 'localhost', 'nagios', 'Sleep', '52', '', NULL, '0.000'
'137615', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '52', '', NULL, '0.000'
'137616', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '6', '', NULL, '0.000'
'137617', 'ndoutils', 'localhost', 'nagios', 'Sleep', '11', '', NULL, '0.000'
'137618', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '52', '', NULL, '0.000'
'137619', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '11', '', NULL, '0.000'
'137620', 'ndoutils', 'localhost', 'nagios', 'Sleep', '52', '', NULL, '0.000'
'137621', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '52', '', NULL, '0.000'
'137628', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '2', '', NULL, '0.000'
'137629', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '0', '', NULL, '0.000'
'137630', 'ndoutils', 'localhost', 'nagios', 'Sleep', '52', '', NULL, '0.000'
'137631', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '52', '', NULL, '0.000'
'137632', 'ndoutils', 'localhost', 'nagios', 'Sleep', '52', '', NULL, '0.000'
'137633', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '52', '', NULL, '0.000'
'137635', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '0', '', NULL, '0.000'
'137637', 'ndoutils', 'localhost', 'nagios', 'Sleep', '52', '', NULL, '0.000'
'137639', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '52', '', NULL, '0.000'
'137649', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '16', '', NULL, '0.000'
'137650', 'ndoutils', 'localhost', 'nagios', 'Sleep', '16', '', NULL, '0.000'
'137651', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '16', '', NULL, '0.000'
'137655', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '26', '', NULL, '0.000'
'137656', 'ndoutils', 'localhost', 'nagios', 'Sleep', '26', '', NULL, '0.000'
'137657', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '26', '', NULL, '0.000'
'137664', 'nagiosxi', 'localhost', 'nagiosxi', 'Sleep', '6', '', NULL, '0.000'
'137665', 'ndoutils', 'localhost', 'nagios', 'Sleep', '6', '', NULL, '0.000'
'137666', 'nagiosql', 'localhost', 'nagiosql', 'Sleep', '6', '', NULL, '0.000'
Any help will be welcomed.
Thanks in advance.
BR,
Juanma.
