Page 1 of 2

After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 3:16 pm
by gdolidze
We updated our 64bit vm to 5.4.1 and the web interface started lagging became really slow, sometimes its even unresponsive.

SLI side is fine.
I tried restarting the server in case something extra was running but everything is still the same.

For example it takes 5 minutes to go to the birdseye page and once there it takes even longer for the service to pop up there.

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 3:21 pm
by avandemore
XI > Admin > System Profile > Download Profile

Please include the zip file in your response. You can PM myself or other support personnel if you have privacy concerns.

Please run this and provide the output:

Code: Select all

# mysql -uroot -pnagiosxi -e '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;'

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 3:33 pm
by gdolidze
Is there any way for me to access the system profile except through the web interface, it unresponsive right now so i cant access it.

Code: Select all

+--------------------+--------------------------------------------+------------+
| Database           | Table                                      | Size in MB |
+--------------------+--------------------------------------------+------------+
| nagios             | nagios_statehistory                        |      54.04 |
| nagios             | nagios_commenthistory                      |      29.15 |
| nagios             | nagios_logentries                          |      28.65 |
| nagios             | nagios_downtimehistory                     |       5.85 |
| nagios             | nagios_notifications                       |       3.80 |
| nagios             | nagios_contactnotifications                |       0.58 |
| nagios             | nagios_contactnotificationmethods          |       0.55 |
| mysql              | help_topic                                 |       0.46 |
| nagios             | nagios_servicestatus                       |       0.31 |
| nagios             | nagios_flappinghistory                     |       0.22 |
| nagios             | nagios_objects                             |       0.16 |
| nagiosql           | tbl_service                                |       0.15 |
| nagiosql           | tbl_info                                   |       0.13 |
| nagios             | nagios_services                            |       0.12 |
| nagios             | nagios_conninfo                            |       0.11 |
| mysql              | help_keyword                               |       0.10 |
| nagios             | nagios_processevents                       |       0.09 |
| nagios             | nagios_comments                            |       0.08 |
| nagios             | nagios_customvariablestatus                |       0.04 |
| nagios             | nagios_acknowledgements                    |       0.04 |
| nagios             | nagios_scheduleddowntime                   |       0.04 |
| nagios             | nagios_customvariables                     |       0.04 |
| nagiosql           | tbl_variabledefinition                     |       0.04 |
| nagios             | nagios_systemcommands                      |       0.04 |
| nagios             | nagios_hoststatus                          |       0.04 |
| nagiosql           | tbl_command                                |       0.03 |
| nagios             | nagios_service_contacts                    |       0.03 |
| nagios             | nagios_externalcommands                    |       0.03 |
| mysql              | help_relation                              |       0.03 |
| nagiosql           | tbl_lnkServiceToHost                       |       0.02 |
| nagiosql           | tbl_lnkServiceToServicetemplate            |       0.02 |
| nagiosql           | tbl_lnkServiceToContact                    |       0.02 |
| nagios             | nagios_commands                            |       0.02 |
| nagiosql           | tbl_lnkServiceToVariabledefinition         |       0.02 |
| nagiosql           | tbl_servicetemplate                        |       0.02 |
| nagiosql           | tbl_host                                   |       0.02 |
| nagiosql           | tbl_hosttemplate                           |       0.01 |
| nagios             | nagios_hosts                               |       0.01 |
| nagios             | nagios_configfilevariables                 |       0.01 |
| nagiosql           | tbl_timeperiod                             |       0.01 |
| nagiosql           | tbl_contact                                |       0.01 |
| nagiosql           | tbl_domain                                 |       0.01 |
| nagiosql           | tbl_hostgroup                              |       0.01 |
| nagiosql           | tbl_user                                   |       0.01 |
| nagiosql           | tbl_contacttemplate                        |       0.01 |
| nagiosql           | tbl_contactgroup                           |       0.01 |
| nagiosql           | tbl_servicegroup                           |       0.01 |
| mysql              | db                                         |       0.01 |
| nagios             | nagios_contact_notificationcommands        |       0.01 |
| nagiosql           | tbl_lnkServicetemplateToServicetemplate    |       0.00 |
| nagios             | nagios_configfiles                         |       0.00 |
| mysql              | help_category                              |       0.00 |
| nagiosql           | tbl_timedefinition                         |       0.00 |
| mysql              | procs_priv                                 |       0.00 |
| nagiosql           | tbl_serviceescalation                      |       0.00 |
| nagiosql           | tbl_servicedependency                      |       0.00 |
| nagiosql           | tbl_hostescalation                         |       0.00 |
| nagiosql           | tbl_hostdependency                         |       0.00 |
| mysql              | columns_priv                               |       0.00 |
| mysql              | tables_priv                                |       0.00 |
| nagios             | nagios_timeperiod_timeranges               |       0.00 |
| nagios             | nagios_eventhandlers                       |       0.00 |
| nagios             | nagios_runtimevariables                    |       0.00 |
| nagios             | nagios_host_contacts                       |       0.00 |
| nagiosql           | tbl_submenu                                |       0.00 |
| nagios             | nagios_contacts                            |       0.00 |
| nagios             | nagios_hostgroup_members                   |       0.00 |
| nagios             | nagios_timeperiods                         |       0.00 |
| nagiosql           | tbl_settings                               |       0.00 |
| nagios             | nagios_contactstatus                       |       0.00 |
| nagios             | nagios_service_contactgroups               |       0.00 |
| nagios             | nagios_servicegroup_members                |       0.00 |
| nagios             | nagios_hostgroups                          |       0.00 |
| nagios             | nagios_contactgroups                       |       0.00 |
| nagios             | nagios_programstatus                       |       0.00 |
| nagios             | nagios_servicegroups                       |       0.00 |
| nagios             | nagios_contactgroup_members                |       0.00 |
| nagios             | nagios_host_contactgroups                  |       0.00 |
| nagiosql           | tbl_lnkHostToHosttemplate                  |       0.00 |
| nagiosql           | tbl_lnkHosttemplateToHosttemplate          |       0.00 |
| mysql              | user                                       |       0.00 |
| nagiosql           | tbl_lnkHostToContact                       |       0.00 |
| nagiosql           | tbl_lnkHostToVariabledefinition            |       0.00 |
| nagiosql           | tbl_lnkHostgroupToHost                     |       0.00 |
| nagiosql           | tbl_mainmenu                               |       0.00 |
| nagiosql           | tbl_lnkServicegroupToService               |       0.00 |
| nagiosql           | tbl_session                                |       0.00 |
| nagiosql           | tbl_lnkServiceToContactgroup               |       0.00 |
| nagiosql           | tbl_lnkServiceToHostgroup                  |       0.00 |
| nagiosql           | tbl_lnkContactToContacttemplate            |       0.00 |
| nagiosql           | tbl_lnkContactToCommandService             |       0.00 |
| nagiosql           | tbl_lnkHosttemplateToContactgroup          |       0.00 |
| nagiosql           | tbl_lnkContactToCommandHost                |       0.00 |
| nagiosql           | tbl_session_locks                          |       0.00 |
| nagios             | nagios_instances                           |       0.00 |
| nagiosql           | tbl_lnkContacttemplateToCommandHost        |       0.00 |
| nagiosql           | tbl_lnkContactgroupToContact               |       0.00 |
| nagiosql           | tbl_lnkContacttemplateToCommandService     |       0.00 |
| nagiosql           | tbl_lnkHostToHostgroup                     |       0.00 |
| nagiosql           | tbl_lnkHosttemplateToHostgroup             |       0.00 |
| nagiosql           | tbl_lnkServicetemplateToContactgroup       |       0.00 |
| nagiosql           | tbl_lnkContacttemplateToContactgroup       |       0.00 |
| mysql              | proc                                       |       0.00 |
| mysql              | event                                      |       0.00 |
| mysql              | host                                       |       0.00 |
| nagios             | nagios_dbversion                           |       0.00 |
| nagiosql           | tbl_lnkServicetemplateToVariabledefinition |       0.00 |
| nagiosql           | tbl_lnkHosttemplateToContact               |       0.00 |
| information_schema | TRIGGERS                                   |       0.00 |
| nagios             | nagios_hostescalation_contactgroups        |       0.00 |
| nagios             | nagios_contact_addresses                   |       0.00 |
| mysql              | servers                                    |       0.00 |
| nagiosql           | tbl_lnkServicedependencyToHostgroup_H      |       0.00 |
| nagiosql           | tbl_serviceextinfo                         |       0.00 |
| information_schema | ROUTINES                                   |       0.00 |
| nagiosql           | tbl_lnkHostgroupToHostgroup                |       0.00 |
| mysql              | time_zone_transition_type                  |       0.00 |
| nagiosql           | tbl_lnkContactgroupToContactgroup          |       0.00 |
| nagiosql           | tbl_lnkServiceescalationToService          |       0.00 |
| nagios             | nagios_hostdependencies                    |       0.00 |
| nagiosql           | tbl_lnkHostToHost                          |       0.00 |
| nagiosql           | tbl_lnkServicedependencyToHostgroup_DH     |       0.00 |
| nagiosql           | tbl_lnkServicetemplateToServicegroup       |       0.00 |
| mysql              | time_zone_transition                       |       0.00 |
| nagiosql           | tbl_lnkServiceescalationToHostgroup        |       0.00 |
| nagios             | nagios_hostchecks                          |       0.00 |
| nagiosql           | tbl_lnkHostToContactgroup                  |       0.00 |
| mysql              | func                                       |       0.00 |
| nagios             | nagios_serviceescalations                  |       0.00 |
| nagiosql           | tbl_lnkServicedependencyToHost_H           |       0.00 |
| nagiosql           | tbl_lnkServicetemplateToHostgroup          |       0.00 |
| nagiosql           | tbl_lnkHostdependencyToHostgroup_DH        |       0.00 |
| mysql              | time_zone_name                             |       0.00 |
| nagiosql           | tbl_lnkContactToVariabledefinition         |       0.00 |
| nagios             | nagios_timedeventqueue                     |       0.00 |
| nagiosql           | tbl_lnkServiceescalationToHost             |       0.00 |
| nagiosql           | tbl_lnkHosttemplateToVariabledefinition    |       0.00 |
| information_schema | EVENTS                                     |       0.00 |
| nagios             | nagios_host_parenthosts                    |       0.00 |
| mysql              | plugin                                     |       0.00 |
| nagiosql           | tbl_hostextinfo                            |       0.00 |
| nagios             | nagios_serviceescalation_contacts          |       0.00 |
| nagiosql           | tbl_lnkServicedependencyToHost_DH          |       0.00 |
| nagiosql           | tbl_lnkHostescalationToHostgroup           |       0.00 |
| mysql              | time_zone_leap_second                      |       0.00 |
| nagiosql           | tbl_lnkServiceescalationToContactgroup     |       0.00 |
| nagiosql           | tbl_lnkContacttemplateToVariabledefinition |       0.00 |
| nagiosql           | tbl_lnkServicetemplateToHost               |       0.00 |
| mysql              | ndb_binlog_index                           |       0.00 |
| nagios             | nagios_serviceescalation_contactgroups     |       0.00 |
| information_schema | PROCESSLIST                                |       0.00 |
| nagiosql           | tbl_lnkHostescalationToHost                |       0.00 |
| nagiosql           | tbl_lnkHostdependencyToHost_H              |       0.00 |
| mysql              | time_zone                                  |       0.00 |
| nagiosql           | tbl_lnkContactToContactgroup               |       0.00 |
| nagiosql           | tbl_lnkServiceescalationToContact          |       0.00 |
| nagiosql           | tbl_lnkContacttemplateToContacttemplate    |       0.00 |
| nagios             | nagios_servicedependencies                 |       0.00 |
| information_schema | PLUGINS                                    |       0.00 |
| nagiosql           | tbl_lnkHostescalationToContactgroup        |       0.00 |
| nagiosql           | tbl_lnkHostdependencyToHost_DH             |       0.00 |
| nagiosql           | tbl_logbook                                |       0.00 |
| nagiosql           | tbl_lnkServicedependencyToService_S        |       0.00 |
| nagios             | nagios_timedevents                         |       0.00 |
| nagiosql           | tbl_lnkHosttemplateToHost                  |       0.00 |
| information_schema | COLUMNS                                    |       0.00 |
| nagiosql           | tbl_lnkServicetemplateToContact            |       0.00 |
| information_schema | VIEWS                                      |       0.00 |
| nagios             | nagios_servicechecks                       |       0.00 |
| nagiosql           | tbl_lnkServiceToServicegroup               |       0.00 |
| information_schema | PARTITIONS                                 |       0.00 |
| nagios             | nagios_hostescalations                     |       0.00 |
| nagiosql           | tbl_lnkHostescalationToContact             |       0.00 |
| nagiosql           | tbl_lnkTimeperiodToTimeperiod              |       0.00 |
| nagiosql           | tbl_lnkServicedependencyToService_DS       |       0.00 |
| nagiosql           | tbl_lnkServicegroupToServicegroup          |       0.00 |
| nagios             | nagios_service_parentservices              |       0.00 |
| nagios             | nagios_hostescalation_contacts             |       0.00 |
| nagiosql           | tbl_lnkHostdependencyToHostgroup_H         |       0.00 |
| information_schema | SCHEMATA                                   |       0.00 |
| information_schema | COLLATIONS                                 |       0.00 |
| information_schema | GLOBAL_VARIABLES                           |       0.00 |
| information_schema | CHARACTER_SETS                             |       0.00 |
| information_schema | TABLE_PRIVILEGES                           |       0.00 |
| information_schema | GLOBAL_STATUS                              |       0.00 |
| mysql              | general_log                                |       0.00 |
| information_schema | TABLE_CONSTRAINTS                          |       0.00 |
| information_schema | FILES                                      |       0.00 |
| information_schema | REFERENTIAL_CONSTRAINTS                    |       0.00 |
| information_schema | TABLES                                     |       0.00 |
| information_schema | PROFILING                                  |       0.00 |
| information_schema | STATISTICS                                 |       0.00 |
| information_schema | ENGINES                                    |       0.00 |
| information_schema | SESSION_VARIABLES                          |       0.00 |
| information_schema | COLUMN_PRIVILEGES                          |       0.00 |
| information_schema | SESSION_STATUS                             |       0.00 |
| information_schema | SCHEMA_PRIVILEGES                          |       0.00 |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY      |       0.00 |
| information_schema | USER_PRIVILEGES                            |       0.00 |
| information_schema | KEY_COLUMN_USAGE                           |       0.00 |
| mysql              | slow_log                                   |       0.00 |
+--------------------+--------------------------------------------+------------+

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 3:41 pm
by avandemore
What is the output of:

Code: Select all

# top -bcn1
Also please attach /var/log/httpd/error_log

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 3:46 pm
by gdolidze

Code: Select all

top - 15:44:31 up  1:53,  1 user,  load average: 0.19, 0.38, 0.51
Tasks: 233 total,   1 running, 232 sleeping,   0 stopped,   0 zombie
Cpu(s): 17.8%us,  1.9%sy,  0.0%ni, 79.8%id,  0.4%wa,  0.0%hi,  0.1%si,  0.0%st
Mem:   4957688k total,  3211144k used,  1746544k free,    54636k buffers
Swap:  2064380k total,        0k used,  2064380k free,  2067500k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 3274 nagios    20   0 50380 2192 1036 S  1.9  0.0   1:05.37 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
    1 root      20   0 19364 1580 1272 S  0.0  0.0   0:02.21 /sbin/init
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthreadd]
    3 root      RT   0     0    0    0 S  0.0  0.0   0:00.86 [migration/0]
    4 root      20   0     0    0    0 S  0.0  0.0   0:00.58 [ksoftirqd/0]
    5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/0]
    6 root      RT   0     0    0    0 S  0.0  0.0   0:00.43 [watchdog/0]
    7 root      RT   0     0    0    0 S  0.0  0.0   0:01.79 [migration/1]
    8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/1]
    9 root      20   0     0    0    0 S  0.0  0.0   0:00.13 [ksoftirqd/1]
   10 root      RT   0     0    0    0 S  0.0  0.0   0:00.25 [watchdog/1]
   11 root      RT   0     0    0    0 S  0.0  0.0   0:01.33 [migration/2]
   12 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/2]
   13 root      20   0     0    0    0 S  0.0  0.0   0:00.03 [ksoftirqd/2]
   14 root      RT   0     0    0    0 S  0.0  0.0   0:00.09 [watchdog/2]
   15 root      RT   0     0    0    0 S  0.0  0.0   0:02.44 [migration/3]
   16 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/3]
   17 root      20   0     0    0    0 S  0.0  0.0   0:00.03 [ksoftirqd/3]
   18 root      RT   0     0    0    0 S  0.0  0.0   0:00.09 [watchdog/3]
   19 root      20   0     0    0    0 S  0.0  0.0   0:02.76 [events/0]
   20 root      20   0     0    0    0 S  0.0  0.0   0:01.80 [events/1]
   21 root      20   0     0    0    0 S  0.0  0.0   0:06.85 [events/2]
   22 root      20   0     0    0    0 S  0.0  0.0   0:01.42 [events/3]
   23 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events/0]
   24 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events/1]
   25 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events/2]
   26 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events/3]
   27 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_long/0]
   28 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_long/1]
   29 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_long/2]
   30 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_long/3]
   31 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_power_ef]
   32 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_power_ef]
   33 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_power_ef]
   34 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [events_power_ef]
   35 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [cgroup]
   36 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [khelper]
   37 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [netns]
   38 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [async/mgr]
   39 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [pm]
   40 root      20   0     0    0    0 S  0.0  0.0   0:00.02 [sync_supers]
   41 root      20   0     0    0    0 S  0.0  0.0   0:00.03 [bdi-default]
   42 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kintegrityd/0]
   43 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kintegrityd/1]
   44 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kintegrityd/2]
   45 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kintegrityd/3]
   46 root      20   0     0    0    0 S  0.0  0.0   0:11.18 [kblockd/0]
   47 root      20   0     0    0    0 S  0.0  0.0   0:12.56 [kblockd/1]
   48 root      20   0     0    0    0 S  0.0  0.0   0:10.44 [kblockd/2]
   49 root      20   0     0    0    0 S  0.0  0.0   0:10.17 [kblockd/3]
   50 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kacpid]
   51 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kacpi_notify]
   52 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kacpi_hotplug]
   53 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ata_aux]
   54 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ata_sff/0]
   55 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ata_sff/1]
   56 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ata_sff/2]
   57 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ata_sff/3]
   58 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ksuspend_usbd]
   59 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [khubd]
   60 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kseriod]
   61 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md/0]
   62 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md/1]
   63 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md/2]
   64 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md/3]
   65 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md_misc/0]
   66 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md_misc/1]
   67 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md_misc/2]
   68 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [md_misc/3]
   69 root      20   0     0    0    0 S  0.0  0.0   0:00.01 [linkwatch]
   72 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [khungtaskd]
   73 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kswapd0]
   74 root      25   5     0    0    0 S  0.0  0.0   0:00.00 [ksmd]
   75 root      39  19     0    0    0 S  0.0  0.0   0:01.30 [khugepaged]
   76 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [aio/0]
   77 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [aio/1]
   78 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [aio/2]
   79 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [aio/3]
   80 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [crypto/0]
   81 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [crypto/1]
   82 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [crypto/2]
   83 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [crypto/3]
   90 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthrotld/0]
   91 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthrotld/1]
   92 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthrotld/2]
   93 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthrotld/3]
   94 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [pciehpd]
   96 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kpsmoused]
   97 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [usbhid_resumer]
   98 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [deferwq]
  130 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kdmremove]
  131 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kstriped]
  155 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ttm_swap]
  405 root      20   0     0    0    0 S  0.0  0.0   0:00.01 [scsi_eh_0]
  406 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [scsi_eh_1]
  412 root      20   0     0    0    0 S  0.0  0.0   0:02.23 [mpt_poll_0]
  413 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [mpt/0]
  414 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [scsi_eh_2]
  492 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kdmflush]
  494 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kdmflush]
  512 root      20   0     0    0    0 S  0.0  0.0   0:13.22 [jbd2/dm-0-8]
  513 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ext4-dio-unwrit]
  594 root      16  -4 11128 1168  328 S  0.0  0.0   0:00.08 /sbin/udevd -d
  773 root      20   0     0    0    0 S  0.0  0.0   0:00.12 [vmmemctl]
 1017 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [jbd2/sda1-8]
 1018 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [ext4-dio-unwrit]
 1055 root      20   0     0    0    0 S  0.0  0.0   0:00.29 [kauditd]
 1179 root      20   0     0    0    0 S  0.0  0.0   2:00.82 [flush-253:0]
 1300 root      20   0  102m 4904 3844 S  0.0  0.1   0:00.20 sshd: root@pts/0
 1392 root      20   0  105m 2008 1540 S  0.0  0.0   0:00.07 -bash
 1792 nagios    20   0 49840 2252 1644 S  0.0  0.0   0:00.05 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
 1803 root      16  -4 93156  872  576 S  0.0  0.0   0:00.87 auditd
 1825 root      20   0  633m 4924 1368 S  0.0  0.1   0:01.24 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5
 1851 rpc       20   0 18980  904  644 S  0.0  0.0   0:00.05 rpcbind
 1873 rpcuser   20   0 23352 1352  904 S  0.0  0.0   0:00.00 rpc.statd
 1900 dbus      20   0 21436  892  648 S  0.0  0.0   0:00.00 dbus-daemon --system
 1957 root      20   0 66236 1248  528 S  0.0  0.0   0:00.01 /usr/sbin/sshd
 1968 root      20   0 21716 1016  780 S  0.0  0.0   0:00.02 xinetd -stayalive -pidfile /var/run/xinetd.pid
 1979 ntp       20   0 30740 2140 1524 S  0.0  0.0   0:00.08 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
 2069 root      20   0  105m 1580 1320 S  0.0  0.0   0:00.02 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/v
 2200 mysql     20   0 2183m  54m 6500 S  0.0  1.1   1:28.09 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --use
 2251 postgres  20   0  210m 6412 5328 S  0.0  0.1   0:01.98 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
 2468 postgres  20   0  174m 1504  416 S  0.0  0.0   0:00.52 postgres: logger process
 2470 postgres  20   0  210m 4396 3272 S  0.0  0.1   0:03.84 postgres: writer process
 2471 postgres  20   0  210m 1764  672 S  0.0  0.0   0:01.92 postgres: wal writer process
 2472 postgres  20   0  211m 2060  780 S  0.0  0.0   0:00.53 postgres: autovacuum launcher process
 2473 postgres  20   0  175m 1792  564 S  0.0  0.0   0:02.14 postgres: stats collector process
 2510 root      20   0 80904 3432 2532 S  0.0  0.1   0:00.09 /usr/libexec/postfix/master
 2522 postfix   20   0 81160 3584 2632 S  0.0  0.1   0:00.04 qmgr -l -t fifo -u
 2523 root      20   0  327m  13m 7300 S  0.0  0.3   0:00.72 /usr/sbin/httpd
 2535 root      20   0  114m 1244  624 S  0.0  0.0   0:00.31 crond
 2547 root      20   0  208m 3540 2452 S  0.0  0.1   0:00.03 smbd -D
 2557 root      20   0  208m 1992  900 S  0.0  0.0   0:00.01 smbd -D
 2559 apache    20   0  444m  32m 5420 S  0.0  0.7   2:19.87 /usr/sbin/httpd
 2560 apache    20   0  447m  36m 4392 S  0.0  0.7   2:22.24 /usr/sbin/httpd
 2561 apache    20   0  441m  30m 4432 S  0.0  0.6   2:22.93 /usr/sbin/httpd
 2562 apache    20   0  446m  35m 4560 S  0.0  0.7   2:19.61 /usr/sbin/httpd
 2563 apache    20   0  447m  36m 4384 S  0.0  0.8   2:33.50 /usr/sbin/httpd
 2564 apache    20   0  441m  30m 4400 S  0.0  0.6   2:30.51 /usr/sbin/httpd
 2565 apache    20   0  441m  31m 4380 S  0.0  0.6   2:24.15 /usr/sbin/httpd
 2566 apache    20   0  450m  39m 4580 S  0.0  0.8   2:32.87 /usr/sbin/httpd
 2569 root      20   0  193m 8208 1716 S  0.0  0.2   0:00.05 /usr/bin/python -Es /usr/bin/fail2ban-server -s /var/run/fail2ban
 2582 nagios    20   0  296m  980  784 S  0.0  0.0   0:01.95 /usr/local/nagios/bin/npcd -d -f /usr/local/nagios/etc/pnp/npcd.c
 2598 postgres  20   0  212m 6380 4072 S  0.0  0.1   0:03.82 postgres: nagiosxi nagiosxi ::1(48822) idle
 2599 postgres  20   0  212m 6652 4328 S  0.0  0.1   0:04.11 postgres: nagiosxi nagiosxi ::1(48824) idle
 2600 postgres  20   0  212m 6308 4012 S  0.0  0.1   0:03.92 postgres: nagiosxi nagiosxi ::1(48826) idle
 2604 apache    20   0  447m  36m 4408 S  0.0  0.7   2:28.74 /usr/sbin/httpd
 2611 ajaxterm  20   0  166m 7836 1400 S  0.0  0.2   0:03.06 python /usr/share/ajaxterm/ajaxterm.py --daemon --port=8022 --uid
 2691 root      20   0  6256 1576 1212 S  0.0  0.0   0:00.05 /opt/Arcserve/ABcmagt/caagentd
 2724 postgres  20   0  212m 6160 3868 S  0.0  0.1   0:04.08 postgres: nagiosxi nagiosxi ::1(48830) idle
 2727 postgres  20   0  212m 6052 3768 S  0.0  0.1   0:03.84 postgres: nagiosxi nagiosxi ::1(48832) idle
 2774 postgres  20   0  212m 6400 4092 S  0.0  0.1   0:03.88 postgres: nagiosxi nagiosxi ::1(48834) idle
 2775 postgres  20   0  212m 6660 4344 S  0.0  0.1   0:04.14 postgres: nagiosxi nagiosxi ::1(48836) idle
 2780 apache    20   0  449m  39m 4468 S  0.0  0.8   2:30.37 /usr/sbin/httpd
 2781 postgres  20   0  212m 6840 4476 S  0.0  0.1   0:03.96 postgres: nagiosxi nagiosxi ::1(48838) idle
 2784 apache    20   0  447m  36m 4428 S  0.0  0.7   2:23.78 /usr/sbin/httpd
 2785 apache    20   0  446m  34m 5420 S  0.0  0.7   2:16.11 /usr/sbin/httpd
 2830 root      20   0  4064  592  508 S  0.0  0.0   0:00.01 /sbin/mingetty /dev/tty1
 2832 root      20   0  4064  588  508 S  0.0  0.0   0:00.00 /sbin/mingetty /dev/tty2
 2834 root      20   0  4064  588  508 S  0.0  0.0   0:00.00 /sbin/mingetty /dev/tty3
 2836 root      20   0  4064  592  508 S  0.0  0.0   0:00.00 /sbin/mingetty /dev/tty4
 2838 root      20   0  4064  592  508 S  0.0  0.0   0:00.00 /sbin/mingetty /dev/tty5
 2839 root      18  -2 11124 1152  316 S  0.0  0.0   0:00.00 /sbin/udevd -d
 2840 root      18  -2 11124 1140  304 S  0.0  0.0   0:00.00 /sbin/udevd -d
 2842 root      20   0  4064  588  508 S  0.0  0.0   0:00.00 /sbin/mingetty /dev/tty6
 2906 postgres  20   0  212m 6100 3816 S  0.0  0.1   0:03.97 postgres: nagiosxi nagiosxi ::1(48904) idle
 2926 apache    20   0  446m  35m 4492 S  0.0  0.7   2:16.83 /usr/sbin/httpd
 2927 postgres  20   0  212m 6428 4124 S  0.0  0.1   0:04.00 postgres: nagiosxi nagiosxi ::1(48934) idle
 2933 postgres  20   0  212m 6676 4352 S  0.0  0.1   0:03.90 postgres: nagiosxi nagiosxi ::1(48950) idle
 2934 postgres  20   0  212m 6848 4488 S  0.0  0.1   0:03.86 postgres: nagiosxi nagiosxi ::1(48952) idle
 2952 root      20   0  136m 1752 1012 S  0.0  0.0   0:00.00 CROND
 2963 nagios    20   0  103m 1276 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php >
 2975 nagios    20   0  322m  32m 8436 S  0.0  0.7   0:01.37 /usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php
 3038 postgres  20   0  212m 6352 4068 S  0.0  0.1   0:00.40 postgres: nagiosxi nagiosxi ::1(49020) idle
 3209 postgres  20   0  212m 6472 4160 S  0.0  0.1   0:03.77 postgres: nagiosxi nagiosxi ::1(49050) idle
 3262 nagios    20   0 24348 5516 1340 S  0.0  0.1   0:30.53 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
 3264 nagios    20   0 10108 1012  684 S  0.0  0.0   0:01.65 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/na
 3265 nagios    20   0 10108 1008  684 S  0.0  0.0   0:01.45 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/na
 3266 nagios    20   0 10108 1008  684 S  0.0  0.0   0:01.42 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/na
 3267 nagios    20   0 10108 1008  684 S  0.0  0.0   0:01.67 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/na
 3268 nagios    20   0 10108 1012  684 S  0.0  0.0   0:01.51 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/na
 3269 nagios    20   0 10108 1012  684 S  0.0  0.0   0:01.45 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/na
 3272 nagios    20   0 49840 1620  912 S  0.0  0.0   0:01.43 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
 3286 nagios    20   0 23840 2360  280 S  0.0  0.0   0:00.87 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
 3758 apache    20   0  450m  38m 5436 S  0.0  0.8   2:14.35 /usr/sbin/httpd
 3786 postgres  20   0  212m 6448 4140 S  0.0  0.1   0:03.70 postgres: nagiosxi nagiosxi ::1(49508) idle
 4050 apache    20   0  442m  31m 4424 S  0.0  0.6   2:21.45 /usr/sbin/httpd
 4085 postgres  20   0  212m 6596 4284 S  0.0  0.1   0:03.87 postgres: nagiosxi nagiosxi ::1(49818) idle
 4353 apache    20   0  444m  33m 4420 S  0.0  0.7   2:17.88 /usr/sbin/httpd
 4442 postgres  20   0  212m 6052 3768 S  0.0  0.1   0:03.73 postgres: nagiosxi nagiosxi ::1(50126) idle
10298 apache    20   0  441m  30m 4396 S  0.0  0.6   2:11.70 /usr/sbin/httpd
10313 postgres  20   0  212m 6264 3972 S  0.0  0.1   0:03.56 postgres: nagiosxi nagiosxi ::1(55756) idle
12353 root      20   0  136m 1748 1012 S  0.0  0.0   0:00.00 CROND
12354 root      20   0  136m 1752 1012 S  0.0  0.0   0:00.00 CROND
12355 root      20   0  136m 1752 1012 S  0.0  0.0   0:00.00 CROND
12356 root      20   0  136m 1752 1012 S  0.0  0.0   0:00.00 CROND
12357 root      20   0  136m 1752 1012 S  0.0  0.0   0:00.00 CROND
12358 root      20   0  136m 1752 1012 S  0.0  0.0   0:00.00 CROND
12359 nagios    20   0  103m 1276 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/event_handler
12360 nagios    20   0  103m 1272 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php
12361 nagios    20   0  103m 1276 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php
12362 nagios    20   0  103m 1276 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.
12364 nagios    20   0  103m 1276 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php
12366 nagios    20   0  103m 1276 1112 S  0.0  0.0   0:00.00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >
12367 nagios    20   0  312m  22m 8016 S  0.0  0.5   0:00.23 /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php
12368 nagios    20   0  322m  32m 8088 S  0.0  0.7   0:00.34 /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php
12369 nagios    20   0  312m  22m 7992 S  0.0  0.5   0:00.22 /usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php
12371 nagios    20   0  312m  23m 8324 S  0.0  0.5   0:00.23 /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php
12374 nagios    20   0  312m  22m 8008 S  0.0  0.5   0:00.22 /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php
12375 nagios    20   0  312m  22m 8052 S  0.0  0.5   0:00.22 /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php
12378 postgres  20   0  212m 6208 3900 S  0.0  0.1   0:00.02 postgres: nagiosxi nagiosxi ::1(33134) idle
12379 postgres  20   0  212m 6136 3824 S  0.0  0.1   0:00.05 postgres: nagiosxi nagiosxi ::1(33136) idle
12381 postgres  20   0  212m 5788 3588 S  0.0  0.1   0:00.00 postgres: nagiosxi nagiosxi ::1(33138) idle
12389 postgres  20   0  212m 4984 2904 S  0.0  0.1   0:00.00 postgres: nagiosxi nagiosxi ::1(33142) idle
12393 postgres  20   0  212m 5804 3600 S  0.0  0.1   0:00.01 postgres: nagiosxi nagiosxi ::1(33146) idle
12394 postgres  20   0  212m 5788 3588 S  0.0  0.1   0:00.00 postgres: nagiosxi nagiosxi ::1(33148) idle
12570 nagios    20   0 41300 2576 1956 S  0.0  0.1   0:00.00 /usr/local/nagios/libexec/check_nrpe -H digital.cjh.org -t 30 -c
12572 root      20   0 15020 1296  884 R  0.0  0.0   0:00.01 top -bcn1
13591 apache    20   0  440m  29m 4440 S  0.0  0.6   1:54.83 /usr/sbin/httpd
13598 postgres  20   0  212m 6432 4128 S  0.0  0.1   0:03.08 postgres: nagiosxi nagiosxi ::1(59018) idle
13735 apache    20   0  441m  30m 4404 S  0.0  0.6   1:58.15 /usr/sbin/httpd
13741 postgres  20   0  212m 6048 3760 S  0.0  0.1   0:03.24 postgres: nagiosxi nagiosxi ::1(59206) idle
14668 apache    20   0  443m  31m 5464 S  0.0  0.6   1:49.22 /usr/sbin/httpd
14678 postgres  20   0  212m 6060 3772 S  0.0  0.1   0:02.90 postgres: nagiosxi nagiosxi ::1(60078) idle
14778 apache    20   0  447m  36m 4392 S  0.0  0.8   1:47.75 /usr/sbin/httpd
14788 postgres  20   0  212m 5936 3648 S  0.0  0.1   0:02.87 postgres: nagiosxi nagiosxi ::1(60250) idle
15484 apache    20   0  446m  35m 4448 S  0.0  0.7   1:44.80 /usr/sbin/httpd
15490 postgres  20   0  212m 6044 3756 S  0.0  0.1   0:02.87 postgres: nagiosxi nagiosxi ::1(60956) idle
17932 apache    20   0  446m  35m 4448 S  0.0  0.7   1:38.63 /usr/sbin/httpd
17937 postgres  20   0  212m 6264 3972 S  0.0  0.1   0:02.66 postgres: nagiosxi nagiosxi ::1(35078) idle
26530 postfix   20   0 80984 3452 2560 S  0.0  0.1   0:00.01 pickup -l -t fifo -u
26675 apache    20   0  440m  29m 4340 S  0.0  0.6   0:49.99 /usr/sbin/httpd
26750 postgres  20   0  212m 5924 3636 S  0.0  0.1   0:01.31 postgres: nagiosxi nagiosxi ::1(43480) idle

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 4:14 pm
by avandemore
You have a lot of errors like this:

Code: Select all

[Wed Feb 01 15:36:31 2017] [error] [client 10.1.3.145] connect() timed out!, referer: http://10.1.1.9/nagiosxi/includes/components/nagioscorecfg/applyconfig.php
[Wed Feb 01 15:36:37 2017] [error] [client 10.1.3.118] connect() timed out!, referer: http://nagiosxi-prod.cfjh.net/nagiosxi/index.php
What are those IP's? Do you have LDAP / AD auth enabled?

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 4:38 pm
by gdolidze
Those would be my IP and my coworkers and we do not have LDAP/AD enabled.
I wouldn't know the cause of the errors, Since the update the web interface takes too long to get anything through.
Might be request errors.

Now when i try to open up the web interface I get Its unresponsive Kill or Wait,
It used to at list go to the home page.

Re: After NagiosXI update web interface has become slugish

Posted: Wed Feb 01, 2017 5:25 pm
by ssax
Do you use Nagios Incident Manager? If not, please run this command:

Code: Select all

mv /usr/local/nagiosxi/html/includes/components/nagiosim /tmp/
Then test it again.

Also, Please PM one of us a copy of your profile, you can download it by going to Admin > System Config > System Profile and click the Download Profile button in the top right corner.


Thank you

Re: After NagiosXI update web interface has become slugish

Posted: Thu Feb 02, 2017 10:09 am
by gdolidze
I moved the file to /tmp but didn't seem to fix the issue.
I also messaged you the profile.

Re: After NagiosXI update web interface has become slugish

Posted: Thu Feb 02, 2017 10:23 am
by dwhitfield
Did this problem happen immediately after upgrade (that's what it sounds like, but I just want to be clear)? From what version did you upgrade? Please attach your upgrade.log to your response.