troubleshooting my db

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
User avatar
benhank
Posts: 1264
Joined: Tue Apr 12, 2011 12:29 pm

Re: troubleshooting my db

Post by benhank »

Before I continue, I just want to say how appre3ciative I am for this help. I know this is a matter of me not knowing linux, and you guys would be in your rights to tell me to get a linux book or class. Thanks guys.

Code: Select all

[root@LkennagiosP01 ~]# free -m
total       used       free     shared    buffers     cached
Mem:         15914      15112        802          0        321       8593
-/+ buffers/cache:       6197       9717
Swap:        18095          5      18090
[root@LkennagiosP01 ~]#

Proudly running:
NagiosXI 5.4.12 2 node Prod Env 2500 hosts, 13,000 services
Nagiosxi 5.5.7(test env) 2500 hosts, 13,000 services
Nagios Logserver 2 node Prod Env 500 objects sending
Nagios Network Analyser
Nagios Fusion
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: troubleshooting my db

Post by abrist »

It looks like your server is just fine. Linux will usually disk cache by keeping recently accessed and commonly used files in memory. The line -/+ buffers shows you what your actual memory usage is, and in your case it is around 6gb. The other 9+ gigs are used by the buffers. This is fine as the buffer memory will deallocate as needed. Now as to what is using 6gb of ram? I can't tell you, but the cli utility "top" could.

The best way to learn about linux is through experience and a search engine. Books will only get you so far, but knowing how to properly craft a search string for google will get you much further, faster. There is a steep curve at the beginning, but once you feel comfortable moving around the cli and know a fair number of the most commonly used commands and file locations, it will become much easier.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
User avatar
benhank
Posts: 1264
Joined: Tue Apr 12, 2011 12:29 pm

Re: troubleshooting my db

Post by benhank »

hey thanks man, I have a fav to ask and a humble suggestion.
Honesty I would never have thought to use the commands you just had me use. I have gotten better with linux since I started using nagios but I have a long way to go.
BTW, for some serious fun and chuckles read my first coupla posts and behold the horror. :o
So here is the fav I am asking for: can you shoot me a list of the commands you use to troubleshoot nagios?
Just the basic "you should know these commands at the least" stuff or the commands you wished guys like me should try before hitting the forums. nothing involved, just your favorite top ten. Just give me the commands, Ill look up what they do and how to use them.
And the request: Is it possible to separate the nagios specific services and processes in addition to whats already in the system status. If I hadn't come here first ... :shock:
Thanks again for the help ya'll. you can lock the thread.
Proudly running:
NagiosXI 5.4.12 2 node Prod Env 2500 hosts, 13,000 services
Nagiosxi 5.5.7(test env) 2500 hosts, 13,000 services
Nagios Logserver 2 node Prod Env 500 objects sending
Nagios Network Analyser
Nagios Fusion
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: troubleshooting my db

Post by slansing »

Here is a brief list of some of the common commands we ask others to run:

Code: Select all

tail /usr/local/nagios/var/nagios.log
- Nagios log, a lot of useful nagios specific information is passed through the log file, and many of the items within the interface parse their info from it.

Code: Select all

tail /usr/local/nagios/var/perfdata.log
- Perfdata log, good for troubleshooting performance data issues

Code: Select all

tail /usr/local/nagios/var/npcd.log
- Similar to the above

Code: Select all

tail /var/log/messages
- System log

Code: Select all

tail /var/log/httpd/error_log
- Apache error log, good for troubleshooting problems within the XI interface as it is handled primarily from apache

Code: Select all

tail /var/log/mysqld.log
- MySQL database log for database reaping or parsing related issues

Those are some of the basic logs that we regularly ask for, and can often provide a resolution on their own, hope that's what you were looking for!
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: troubleshooting my db

Post by abrist »

benhank wrote:So here is the fav I am asking for: can you shoot me a list of the commands you use to troubleshoot nagios?
first of all, you can pull up manuals on commands from the cli in linux with the "man" command. So lets say you want to know about "free". The command to pull up a manual is:

Code: Select all

man free
To exit the manual, press "q".

Here are some links with basic linux commands, essentially cheat sheets for the cli:

http://centoshelp.org/resources/command ... -commands/
http://www.my-guides.net/en/guides/linu ... x-commands
http://www.almightyservers.com/archives/33
benhank wrote:And the request: Is it possible to separate the nagios specific services and processes in addition to whats already in the system status. If I hadn't come here first
Most of the time, you parse output from the cli with "grep" / "awk" / "sed" among others. So if you want to see all nagios processes, you can use ps (process list) and grep the output:

Code: Select all

ps -aef | grep nagios
Nagios XI uses the processes:

Code: Select all

httpd (apache web server)
mysqld
postres
nagios
crond
php
xinetd
ndo2db
npcd
For plugins:

Code: Select all

python
perl
php
bash (shell scripts)
nrpe
nsca
There are probably others as well.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
User avatar
benhank
Posts: 1264
Joined: Tue Apr 12, 2011 12:29 pm

Re: troubleshooting my db

Post by benhank »

indeed bro Lock it nothin to see here.
Proudly running:
NagiosXI 5.4.12 2 node Prod Env 2500 hosts, 13,000 services
Nagiosxi 5.5.7(test env) 2500 hosts, 13,000 services
Nagios Logserver 2 node Prod Env 500 objects sending
Nagios Network Analyser
Nagios Fusion
Locked