External commands

[slansing]

Ahh, that could be a "bit" stressful on the core's, have you thought about offloading the database or initializing a ram disk on the Nagios server?

[David.adder]

Do you refeer to this? http://assets.nagios.com/downloads/nagi ... Server.pdf

Which impact would this have in Nagios?

[scottwilkerson]

Yes and
http://assets.nagios.com/downloads/nagi ... Server.pdf

In a post you showed earlier you had 19% IO Wait time, doing both of these should help reduce that significantly

[David.adder]

Hi Scott,

I'm trying to offload the MySQL from Nagios to an external server, and I get this error message when I type this command: mysqldump -u root -p'nagiosxi' nagios | mysql -u nagios -p'nagios' -h "remote_ip_address" nagios

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `nagios_notifications`

Before doing that I stopped Nagios and Ndo2db

[scottwilkerson]

Lets make sure our local database isn't corrupt by running the following first

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios

[David.adder]

Hi,

I ran that command, not error were found, and Repair was fine:

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges.MYI'
Data records: 194
- Fixing index 1
- Fixing index 2
Iniciando mysqld: [ OK ]
~

===============
REPAIR COMPLETE
===============
Tiene correo en /var/spool/mail/root

But still get the same error message after 15 min working :
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `nagios_notifications` at row: 1934

[scottwilkerson]

Let's do this in 2 parts to see which side we are losing

Code: Select all

mysqldump -u root -p'nagiosxi' nagios > /tmp/nagios.sql

If that succeeds lets run

Code: Select all

cat /tmp/nagios.sql | mysql -u nagios -p'nagios' -h "remote_ip_address" nagios