Re: [Nagios-devel] NDOutils MySQL performance issues

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Guest

Re: [Nagios-devel] NDOutils MySQL performance issues

Post by Guest »

This is a cryptographically signed message in MIME format.

--------------ms020206060405020602030702
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

Hi,

Thorsten T=FCllmann schrieb:
> since I had some issues with slow queries on my MySQL-DB, I digged a bi=
t
> deeper into the NDO database scheme. I would recommend to add some indi=
ces:

one more that showed up in the logs:

CREATE INDEX scheduled_time_idx on nagios_timedevents (scheduled_time);


Since there was no feedback to my last mail, will there be updates to
NDO anytime soon? There are some rumours about a rewrite from scratch.
Maybe Ethan will tell some news in N=FCrnberg next week?

Regards,
Thorsten


--------------ms020206060405020602030702
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

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIITWTCC
BCEwggMJoAMCAQICAgDHMA0GCSqGSIb3DQEBBQUAMHExCzAJBgNVBAYTAkRFMRwwGgYDVQQK
ExNEZXV0c2NoZSBUZWxla29tIEFHMR8wHQYDVQQLExZULVRlbGVTZWMgVHJ1c3QgQ2VudGVy
MSMwIQYDVQQDExpEZXV0c2NoZSBUZWxla29tIFJvb3QgQ0EgMjAeFw0wNjEyMTkxMDI5MDBa
Fw0xOTA2MzAyMzU5MDBaMFoxCzAJBgNVBAYTAkRFMRMwEQYDVQQKEwpERk4tVmVyZWluMRAw
DgYDVQQLEwdERk4tUEtJMSQwIgYDVQQDExtERk4tVmVyZWluIFBDQSBHbG9iYWwgLSBHMDEw
ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDpm8NnhfkNrvWNVMOWUDU9YuluTO2U
1wBblSJ01CDrNI/W7MAxBAuZgeKmFNJSoCgjhIt0iQReW+DieMF4yxbLKDU5ey2QRdDtoAB6
fL9KDhsAw4bpXCsxEXsM84IkQ4wcOItqaACa7txPeKvSxhObdq3u3ibo7wGvdA/BCaL2a869
080UME/15eOkyGKbghoDJzANAmVgTe3RCSMqljVYJ9N2xnG2kB3E7f81hn1vM7PbD8URwoqD
oZRdQWvY0hD1TP3KUazZve+Sg7va64sWVlZDz+HVEz2mHycwzUlU28kTNJpxdcVs6qcLmPkh
nSevPqM5OUhqjK3JmfvDEvK9AgMBAAGjgdkwgdYwcAYDVR0fBGkwZzBloGOgYYZfaHR0cDov
L3BraS50ZWxlc2VjLmRlL2NnaS1iaW4vc2VydmljZS9hZl9Eb3dubG9hZEFSTC5jcmw/LWNy
bF9mb3JtYXQ9WF81MDkmLWlzc3Vlcj1EVF9ST09UX0NBXzIwHQYDVR0OBBYEFEm3xs/oPR9/
6kR7Eyn38QpwPt5kMB8GA1UdIwQYMBaAFDHDeRu69VPXF+CJei0XbAqzK50zMA4GA1UdDwEB
/wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgECMA0GCSqGSIb3DQEBBQUAA4IBAQA74Vp3wEgX
3KkY7IGvWonwvSiSpspZGBJw7Cjy565/lizn8l0ZMfYTK3S9vYCyufdnyTmieTvhERHua3iR
M347XyYndVNljjNj7s9zw7CSI0khUHUjoR8Y4pSFPT8z6XcgjaK95qGFKUD2P3MyWA0Ja6ba
hWzAP7uNZmRWJE6uDT8yNQFb6YyC2XJZT7GGhfF0hVblw/hc843uR7NTBXDn5U2KaYMo4RMJ
hp5eyOpYHgwf+aTUWgRo/Sg+iwK2WLX2oSw3VwBnqyNojWOl75lrXP1LVvarQIc01BGSbOyH
xQoLBzNytG8MHVQs2FHHzL8w00Ny8TK/jM5JY6gA9/IcMIIE9DCCA9ygAwIBAgIECxhKijAN
BgkqhkiG9w0BAQUFADBaMQswCQYDVQQGEwJERTETMBEGA1UEChMKREZOLVZlcmVpbjEQMA4G
A1UECxMHREZOLVBLSTEkMCIGA1UEAxMbREZOLVZlcmVpbiBQQ0EgR2xvYmFsIC0gRzAxMB4X
DTA3MDkyNTA4NTUyNFoXDTE5MDYzMDAwMDAwMFowZTELMAkGA1UEBhMCREUxHzAdBgNVBAoT
FlVuaXZlcnNpdGFldCBLYXJsc3J1aGUxETAPBgNVBAMTCFVOSUtBLUNBMSIwIAYJKoZIhvcN
AQkBFhNjYUB1bmkta2FybHNydWhlLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKC
AQEA77+O1naOz0DfaZqlEljFfwxgJ/1gYmiU585//hyLmfO5Ymkv9iYLCFE39on2kTdXX1BG
8pHaXJLSOPicQHXODWqBKcvxSzKj9BBFCygBcTyDBYtIQ0vbps15rDefDD+WRNFKcXAuTouW
3Nafgb2K81UeTxO2zgzIGxdAPfmRTNuvRNyOLjnpYtMIJGJNgrqb3/k5YNiVkPdL+XhvNxx8
OBU51A/9WTO6WnEEH/emDmyL8xsrcmwainhKMhNR42QmobRXy6ZI5YZfNWho2+WxzJ5i70MR
gd3lE69i0PRUXYXTZbaKNM43R6HFiHNV283GJUD7vHfP0DjBtxlXVDcVgQIDAQABo4IBtTCC
AbEwEgYDVR0TAQH/BAgwBgEB/wIBATALBgNVHQ8EBAMCAQYwHQYDVR0OBBYEFOfA4QXGKUUt
kwnpL5+Qh56LbPi7MB8GA1UdIwQYMBaAFEm3xs/oPR9/6kR7Eyn38QpwPt5kMB4GA1UdEQQX
MBWBE2NhQHVuaS1rYXJsc3J1aGUuZGUwgYgGA1UdHwSBgDB+MD2gO6A5hjdodHRwOi8vY2Rw
MS5wY2EuZGZuLmRlL2dsb2JhbC1yb290LWNhL3B1Yi9jcmwvY2FjcmwuY3JsMD2gO6A5hjdo
dHRwOi8vY2RwMi5wY2EuZGZuLmRlL2dsb2JhbC1yb290LWNhL3B1Yi9jcmwvY2FjcmwuY3Js
MIGiBggrBgEFBQcBAQSBlTCBkjBHBggrBgEFBQcwAoY7aHR0cDovL2NkcDEucGNhLmRmbi5k
ZS9nbG9iYWwtcm9vdC1jYS9wdWIvY2FjZXJ0L2NhY2VydC5jcnQwRwYIKwYBBQUHMAKGO2h0
dHA6Ly9jZHAyLnBjYS5kZm4uZGUvZ2xvYmFsLXJvb3QtY2EvcHViL2NhY2VydC9jYWNlcnQu
Y3J0MA0GCSqGSIb3DQEBBQUAA4IBAQBbsSfNXhlnxGEqIzs9JozshHYgvCQBS5OREEimxtxd
OYFcUaxfweGZj46ghF5BIuIvXIkoNts7AgT+YTrdAmOSX7szVYi229KyNO/NT6g/H0br6rcC
FoGAKrbvd+Fz4nnw4+29nziJ9QTjxizPMAPRlNMM50NlVvibClA1x/zX50rJxDUWCc7QyfgI
ZJLC0HUjIHgvZwxvZgN0gbIz80seI5ULbcAqRo29X4JsvwH04jxcmVtW41WixtAZfd8JtoZ

...[email truncated]...


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