Nagios Support Forum

This is a cryptographically signed message in MIME format.

--------------ms090802050308050503040301
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

Hi,

since I had some issues with slow queries on my MySQL-DB, I digged a bit
deeper into the NDO database scheme. I would recommend to add some indices:

CREATE INDEX start_time_idx on nagios_hostchecks (start_time);
CREATE INDEX start_time_idx on nagios_servicechecks (start_time);
CREATE INDEX scheduled_time_idx on nagios_timedeventqueue (scheduled_time);

Some of the DELETE operations depend on these columns in their WHERE
statement and the performance gain was quite impressive.

My DB has about 1.5GB size running locally on the nagios host. Load15
used to be around 1.7. Right now the numbers look quite different:
load average: 0.18, 0.39, 0.34.


Furthermore I had some strange errors in my syslog looking like:

ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_configfilevariables SET instance_id='1', configfile_id='101',
varname='cfg_file',
varvalue='/usr/local/nagios/etc/objects/contacts-extern\.cfg''

Obviously the unique key in nagios_configfilevariables is not that
unique. Something like

ALTER TABLE `nagios_configfilevariables` DROP INDEX `instance_id` ,
ADD INDEX `instance_id` ( `instance_id` , `configfile_id` )

should do the trick.

ciao,
Thorsten


--------------ms090802050308050503040301
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIZUTCC
Bd4wggTGoAMCAQICAgUIMA0GCSqGSIb3DQEBBAUAMIGHMQswCQYDVQQGEwJERTEfMB0GA1UE
ChMWVW5pdmVyc2l0YWV0IEthcmxzcnVoZTEWMBQGA1UECxMNUmVjaGVuemVudHJ1bTEbMBkG
A1UEAxMSVU5JS0EtQ0EgMjAwNS0yMDA4MSIwIAYJKoZIhvcNAQkBFhNjYUB1bmkta2FybHNy
dWhlLmRlMB4XDTA3MDEyNTEzNTcwM1oXDTA4MTAyNjEzNTcwM1owgYkxCzAJBgNVBAYTAkRF
MR8wHQYDVQQKDBZVbml2ZXJzaXRhZXQgS2FybHNydWhlMRYwFAYDVQQLDA1SZWNoZW56ZW50
cnVtMR0wGwYDVQQDDBRVTklLQS1VLUNBIDIwMDctMjAwODEiMCAGCSqGSIb3DQEJARYTY2FA
dW5pLWthcmxzcnVoZS5kZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAM69rnv8
VUD+x+9Vhmd27k7cnDH0ELLw0nC115q+z0AFVPNaLy5XiGO/a/ebqVd+sP8QVgQ/zEnSnZkS
LOLpq1UWrrn2FutPntVivtaJGFOuJbUQVxbLHO9XURwToDlMRpLXrj+E0to2o/bkSMxrfVT7
KynsDIMy9GoOJ0IXkAkoGgRrU6KrPdUfSHPkctvrxevbmXK/eAG3LoMMbR1KccCQvFJB6Zwe
x/a78E1a3vJcbZaEMam/R9ZuZ4uovQCauZy0J0HxHPkUbae1MHi3uUyJSc+rLtuCbykIcXrk
sr/uLqEegEZwRIH31lh42rB+AR3BGswmDed/BppQXtvq1BECAwEAAaOCAk4wggJKMA8GA1Ud
EwEB/wQFMAMBAf8wCwYDVR0PBAQDAgEGMB0GA1UdDgQWBBRVqG1MFsKQgY5oeDsYQkiyLl/v
sTCB3AYDVR0jBIHUMIHRgBTi9bqXewNoI4RTH5Ptrqs2nfugmqGBsqSBrzCBrDELMAkGA1UE
BhMCREUxITAfBgNVBAoTGERldXRzY2hlcyBGb3JzY2h1bmdzbmV0ejEWMBQGA1UECxMNREZO
LUNFUlQgR21iSDEQMA4GA1UECxMHREZOLVBDQTEtMCsGA1UEAxMkREZOIFRvcGxldmVsIENl
cnRpZmljYXRpb24gQXV0aG9yaXR5MSEwHwYJKoZIhvcNAQkBFhJjZXJ0aWZ5QHBjYS5kZm4u
ZGWCBAWcYZMwEQYJYIZIAYb4QgEBBAQDAgAHMC4GCWCGSAGG+EIBAgQhFh9odHRwOi8vd3d3
LnJ6LnVuaS1rYXJsc3J1aGUuZGUvMDEGCWCGSAGG+EIBCAQkFiJodHRwOi8vd3d3LnJ6LnVu
aS1rYXJsc3J1aGUuZGUvY2EvMCQGCWCGSAGG+EIBAwQXFhVjZ2ktYmluL3VuaWthLTA1LXJl
dj8wgY8GCWCGSAGG+EIBDQSBgRZ/VGhpcyBjZXJ0aWZpY2F0ZSB3YXMgaXNzdWVkIGZvciB1
c2UgYXMgYSBzdWItQ0EgdW5kZXIgdGhlIFVOSUtBLUNBLCB0aGUgQ2VydGlmaWNhdGlvbiBB
dXRob3JpdHkgb2YgdGhlIFVuaXZlcnNpdHkgb2YgS2FybHNydWhlLjANBgkqhkiG9w0BAQQF
AAOCAQEAm94wyFB3bg/YRJw87w/BiZ680JNHhroGgB9P2NBkcPcJtRqX8HHWIhddzVNv1yXH
KkfqG/Y2u+dNKojA6gGC/DMTygArH54WsdlP37+6+KGUzKPnu/dEOyJ9XsigkbU5LqXSAjqz
LKc1CqbePCUo5H6mUPK4UiLfqgGxds1pCY4Owxt10A5oLcX/L++Gv6mWLWaOv1hUWxlsA+9P
ln7GMSs0sw8Sn66WV6reKTwq96MCcNshOZJObMkwxluXtmKSuD5HZEC3Jni02YYKnc3OC1yb
7jkABz9a2vRYq7BwpJCDo1S1FGyYXDdly6Utcl6b79I/LGu2cCNPz82U8IqQIDCCBfYwggTe
oAMCAQICAWUwDQYJKoZIhvcNAQEFBQAwgYkxCzAJBgNVBAYTAkRFMR8wHQYDVQQKDBZVbml2
ZXJzaXRhZXQgS2FybHNydWhlMRYwFAYDVQQLDA1SZWNoZW56ZW50cnVtMR0wGwYDVQQDDBRV
TklLQS1VLUNBIDIwMDctMjAwODEiMCAGCSqGSIb3DQEJARYTY2FAdW5pLWthcmxzcnVoZS5k
ZTAeFw0wNzA4MzAxMDM5NTRaFw0wODA4MjkxMDM5NTRaMHcxCzAJBgNVBAYTAkRFMR8wHQYD
VQQKDBZVbml2ZXJzaXRhZXQgS2FybHNydWhlMRwwGgYDVQQLDBNNaXRnbGllZCBkZXIgVW5p


...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: ?ISO-8859-15?Q?Thorsten_T=FCllmann?