High Memory used on nagios xi

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
DonForigua
Posts: 94
Joined: Thu Oct 07, 2021 8:59 pm

High Memory used on nagios xi

Post by DonForigua »

Hello

I have 2 nagios server

Server A (OL7) has 1200 host and 14000 services, the memory use is not more than 4 GB

Server B (OL8) has 202 Host and 1600 services, the memory use is near than 80 - 90 GB

This morning i've restarted the server B and now is normal but the memory use grow with the time.

Code: Select all

● nagios.service - Nagios Core 4.4.6
   Loaded: loaded (/usr/lib/systemd/system/nagios.service; enabled; vendor preset: disabled)                                                                           
   Active: active (running) since Mon 2021-12-06 08:17:47 -05; 6h ago
     Docs: https://www.nagios.org/documentation                                                                                                                        
  Process: 5693 ExecStart=/usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg (code=exited, status=0/SUCCESS)                                             
  Process: 4941 ExecStartPre=/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg (code=exited, status=0/SUCCESS)                                          
 Main PID: 5696 (nagios)                                                                                                                                               
    Tasks: 56 (limit: 817654)                                                                                                                                          
   Memory: 94.1M                                                                                                                                                       
   CGroup: /system.slice/nagios.service                                                                                                                                
           ├─  5696 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg                                                                                   
           ├─  5709 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5710 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5711 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5712 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5713 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5714 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5715 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5716 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5717 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5718 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5719 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5720 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5721 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5722 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5723 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5724 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5725 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5726 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5727 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5728 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5729 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5731 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5732 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5734 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5736 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5737 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5738 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5739 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5740 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5741 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh                                                                           
           ├─  5742 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh

Code: Select all

top - 14:47:46 up  6:30,  3 users,  load average: 0.06, 0.12, 0.17                                                                                                     
Tasks: 941 total,   1 running, 940 sleeping,   0 stopped,   0 zombie                                                                                                   
%Cpu(s):  0.2 us,  0.2 sy,  0.0 ni, 99.6 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st                                                                                        
MiB Mem : 127858.1 total, 114962.0 free,  10575.0 used,   2321.1 buff/cache                                                                                            
MiB Swap:   5120.0 total,   5120.0 free,      0.0 used. 116225.8 avail Mem                                                                                             


    PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND                                                                                        
   2742 root      20   0  129868  14188   7868 S   3.3   0.0   1:42.46 pmdaproc                                                                                        
   4586 pcp       20   0  182168  67560   7432 S   3.0   0.1   0:43.31 pmlogger                                                                                        
   2773 root      20   0  111492   8956   6624 S   2.0   0.0   1:18.85 pmdalinux                                                                                       
 191902 root      20   0  276104   6004   4308 R   1.0   0.0   0:00.20 top                                                                                             
   2750 root      20   0   96852   6952   5868 S   0.7   0.0   0:26.41 pmdaxfs                                                                                         
   3109 root      20   0 4302664 242936 222516 S   0.7   0.2   0:10.59 cvd                                                                                             
     11 root      20   0       0      0      0 I   0.3   0.0   0:17.89 rcu_sched                                                                                       
   1884 root      20   0  125532   6048   4844 S   0.3   0.0   0:31.29 irqbalance                                                                                      
   1957 shellin+  20   0   39724   6612   5356 S   0.3   0.0   0:00.48 shellinaboxd                                                                                    
   4448 root      20   0  490476  28544  12688 S   0.3   0.0   0:07.99 python3                                                                                         
   6018 nagios    20   0 1331320  33952   1380 S   0.3   0.0   0:01.09 nagios                                                                                          
   6777 root      20   0  652304  17716  13492 S   0.3   0.0   0:01.80 goa-identity-se                                                                                 
   6806 root      20   0  419136  32608  10612 S   0.3   0.0   0:25.25 sssd_kcm                                                                                        
 186891 root      20   0       0      0      0 I   0.3   0.0   0:00.60 kworker/0:0-mm_percpu_wq                                                                        
 191663 nagios    20   0  496508  37452  20696 S   0.3   0.0   0:00.13 php                                                                                             
      1 root      20   0  252476  12476   8712 S   0.0   0.0   0:46.75 systemd                                                                                         
      2 root      20   0       0      0      0 S   0.0   0.0   0:00.12 kthreadd                                                                                        
      3 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 rcu_gp
We use nagios xi 5.8.6

Thx
You do not have the required permissions to view the files attached to this post.
Top
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: High Memory used on nagios xi

Post by dchurch »

Please try running the database repair script, and let me know if that is successful. Run the following as root from the terminal.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
See Repairing The Nagios XI Database for complete instructions

...THEN if that doesn't do the trick, please PM me a system profile from the machine you're having problems with (Machine B) so I can diagnose further. Get one by going to Admin (top menu) => System Profile (in the left menu), then clicking the blue button.

If you're unable to generate the the profile through the web interface, please try generating it from the command line by running these commands as root:

Code: Select all

rm -rf /usr/local/nagiosxi/var/components/profile*
/usr/local/nagiosxi/scripts/components/getprofile.sh SUPPORT
Then send me the resulting /usr/local/nagiosxi/var/components/profile.zip file.
If the profile script fails, please include the ENTIRE output.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Top
DonForigua
Posts: 94
Joined: Thu Oct 07, 2021 8:59 pm

Re: High Memory used on nagios xi

Post by DonForigua »

Hi folks

Here the exit of repair script

Code: Select all

DATABASE: nagios                                                                                                                           
TABLE:                                                                                                                                     
mysqlcheck: [Warning] Using a password on the command line interface can be insecure.                                                      
nagios.nagios_acknowledgements                     OK                                                                                      
nagios.nagios_commands                             OK                                                                                      
nagios.nagios_commenthistory                       OK                                                                                      
nagios.nagios_comments                             OK                                                                                      
nagios.nagios_configfiles                          OK                                                                                      
nagios.nagios_configfilevariables                  OK                                                                                      
nagios.nagios_contact_addresses                    OK                                                                                      
nagios.nagios_contact_notificationcommands         OK                                                                                      
nagios.nagios_contactgroup_members                 OK                                                                                      
nagios.nagios_contactgroups                        OK                                                                                      
nagios.nagios_contactnotificationmethods           OK                                                                                      
nagios.nagios_contactnotifications                 OK                                                                                      
nagios.nagios_contacts                             OK                                                                                      
nagios.nagios_contactstatus                        OK                                                                                      
nagios.nagios_customvariables                      OK                                                                                      
nagios.nagios_customvariablestatus                 OK                                                                                      
nagios.nagios_dbversion                            OK                                                                                      
nagios.nagios_downtimehistory                      OK                                                                                      
nagios.nagios_eventhandlers                        OK                                                                                      
nagios.nagios_externalcommands                     OK                                                                                      
nagios.nagios_flappinghistory                      OK                                                                                      
nagios.nagios_host_contactgroups                   OK                                                                                      
nagios.nagios_host_contacts                        OK                                                                                      
nagios.nagios_host_parenthosts                     OK                                                                                      
nagios.nagios_hostchecks                           OK                                                                                      
nagios.nagios_hostdependencies                     OK                                                                                      
nagios.nagios_hostescalation_contactgroups         OK                                                                                      
nagios.nagios_hostescalation_contacts              OK                                                                                      
nagios.nagios_hostescalations                      OK                                                                                      
nagios.nagios_hostgroup_members                    OK                                                                                      
nagios.nagios_hostgroups                           OK                                                                                      
nagios.nagios_hosts                                OK                                                                                      
nagios.nagios_hoststatus                           OK                                                                                      
nagios.nagios_instances                            OK                                                                                      
nagios.nagios_logentries                           OK                                                                                      
nagios.nagios_notifications                        OK                                                                                      
nagios.nagios_objects                              OK                                                                                      
nagios.nagios_processevents                        OK                                                                                      
nagios.nagios_programstatus                        OK                                                                                      
nagios.nagios_runtimevariables                     OK                                                                                      
nagios.nagios_scheduleddowntime                    OK                                                                                      
nagios.nagios_service_contactgroups                OK                                                                                      
nagios.nagios_service_contacts                     OK                                                                                      
nagios.nagios_service_parentservices               OK                                                                                      
nagios.nagios_servicechecks                        OK                                                                                      
nagios.nagios_servicedependencies                  OK                                                                                      
nagios.nagios_serviceescalation_contactgroups      OK                                                                                      
nagios.nagios_serviceescalation_contacts           OK                                                                                      
nagios.nagios_serviceescalations                   OK                                                                                      
nagios.nagios_servicegroup_members                 OK                                                                                      
nagios.nagios_servicegroups                        OK                                                                                      
nagios.nagios_services                             OK                                                                                      
nagios.nagios_servicestatus                        OK                                                                                      
nagios.nagios_statehistory                         OK                                                                                      
nagios.nagios_systemcommands                       OK                                                                                      
nagios.nagios_timedeventqueue                      OK                                                                                      
nagios.nagios_timedevents                          OK                                                                                      
nagios.nagios_timeperiod_timeranges                OK                                                                                      
nagios.nagios_timeperiods                          OK                                                                                      
Issued remote command 'mysqlcheck -f -r -u nagios -pXXXXXX -h XXXXX --port=3306 --databases nagios'                                  
DATABASE: nagiosql                                                                                                                         
TABLE:                                                                                                                                     
mysqlcheck: [Warning] Using a password on the command line interface can be insecure.                                                      
nagiosql.tbl_command                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_contact                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_contactgroup                                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_contacttemplate                                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_domain                                                                                                                        
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_host                                                                                                                          
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_hostdependency                                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_hostescalation                                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_hostextinfo                                                                                                                   
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_hostgroup                                                                                                                     
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_hosttemplate                                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_info                                                                                                                          
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactToCommandHost                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactToCommandService                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactToContactgroup                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactToContacttemplate                                                                                                   
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactToVariabledefinition                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactgroupToContact                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContactgroupToContactgroup                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContacttemplateToCommandHost                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContacttemplateToCommandService                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContacttemplateToContactgroup                                                                                              
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContacttemplateToContacttemplate                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkContacttemplateToVariabledefinition                                                                                        
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostToContact                                                                                                              
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostToContactgroup                                                                                                         
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostToHost                                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostToHostgroup                                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostToHosttemplate                                                                                                         
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostToVariabledefinition                                                                                                   
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostdependencyToHost_DH                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostdependencyToHost_H                                                                                                     
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostdependencyToHostgroup_DH                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostdependencyToHostgroup_H                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostescalationToContact                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostescalationToContactgroup                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostescalationToHost                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostescalationToHostgroup                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostgroupToHost                                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHostgroupToHostgroup                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHosttemplateToContact                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHosttemplateToContactgroup                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHosttemplateToHost                                                                                                         
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHosttemplateToHostgroup                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHosttemplateToHosttemplate                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkHosttemplateToVariabledefinition                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToContact                                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToContactgroup                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToHost                                                                                                              
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToHostgroup                                                                                                         
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToServicegroup                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToServicetemplate                                                                                                   
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceToVariabledefinition                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToHost_DH                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToHost_H                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToHostgroup_DH                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToHostgroup_H                                                                                             
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToService_DS                                                                                              
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToService_S                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToServicegroup_DS                                                                                         
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicedependencyToServicegroup_S                                                                                          
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceescalationToContact                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceescalationToContactgroup                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceescalationToHost                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceescalationToHostgroup                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceescalationToService                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServiceescalationToServicegroup                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicegroupToService                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicegroupToServicegroup                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToContact                                                                                                   
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToContactgroup                                                                                              
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToHost                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToHostgroup                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToServicegroup                                                                                              
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToServicetemplate                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkServicetemplateToVariabledefinition                                                                                        
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_lnkTimeperiodToTimeperiod                                                                                                     
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_logbook                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_mainmenu                                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_permission                                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_permission_inactive                                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_service                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_servicedependency                                                                                                             
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_serviceescalation                                                                                                             
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_serviceextinfo                                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_servicegroup                                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_servicetemplate                                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_session                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_session_locks                                                                                                                 
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_settings                                                                                                                      
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_submenu                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_timedefinition                                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_timeperiod                                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_user                                                                                                                          
note     : The storage engine for the table doesn't support repair                                                                         
nagiosql.tbl_variabledefinition                                                                                                            
note     : The storage engine for the table doesn't support repair                                                                         
Issued remote command 'mysqlcheck -f -r -u nagiosql -pXXXXXXX -h XXXXXX --port=3306 --databases nagiosql'                              
DATABASE: nagiosxi                                                                                                                         
TABLE:                                                                                                                                     
mysqlcheck: [Warning] Using a password on the command line interface can be insecure.                                                      
nagiosxi.xi_auditlog                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_auth_tokens                                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_cmp_ccm_backups                                                                                                                
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_cmp_favorites                                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_cmp_nagiosbpi_backups                                                                                                          
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_cmp_scheduledreports_log                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_cmp_trapdata                                                                                                                   
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_cmp_trapdata_log                                                                                                               
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_commands                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_deploy_agents                                                                                                                  
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_deploy_jobs                                                                                                                    
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_eventqueue                                                                                                                     
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_events                                                                                                                         
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_meta                                                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_mibs                                                                                                                           
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_options                                                                                                                        
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_sessions                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_sysstat                                                                                                                        
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_usermeta                                                                                                                       
note     : The storage engine for the table doesn't support repair                                                                         
nagiosxi.xi_users                                                                                                                          
note     : The storage engine for the table doesn't support repair                                                                         
Issued remote command 'mysqlcheck -f -r -u nagiosxi -pXXXXXX -h XXXXX --port=3306 --databases nagiosxi'                              
                                                                                                                                           
=======================                                                                                                                    
nagios offloaded database repair succeeded                                                                                                 
nagiosql offloaded database repair succeeded                                                                                               
nagiosxi offloaded database repair succeeded
i will send you my profile

Greetings
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: High Memory used on nagios xi

Post by ssax »

Please try making these changes on the OL8 system:
php-fpm timeout issue.txt
You do not have the required permissions to view the files attached to this post.
Top
DonForigua
Posts: 94
Joined: Thu Oct 07, 2021 8:59 pm

Re: High Memory used on nagios xi

Post by DonForigua »

Great the memory is now stable on 11 GB,

Thx for your help
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: High Memory used on nagios xi

Post by ssax »

That's great to hear! Are we okay to lock the topic and mark it as resolved?
Top
Locked

Return to “Nagios XI”