--------------ms020502030009030901050801
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi Kevin,
Kevin Menard wrote:
>
> I'd highly recommend using InnoDB. Actually, I'd recommend using
> PostgreSQL, but it's not my intention to start a flame war. Given the
> critical nature of the data being logged, I'd ensure data consistency with
> InnoDB tables.
>
Looking at my MySQL based NDO DB with 7000+ Service Checks I can see
tons of inserts every second.
I've only heard that PostgreSQL might be better in performance and for
this huge amount of data.
I also do not want a flame war too, but I would just like to know what
other people are thinking in the manner MySQL vs. PostgresQL.
Up to now I can say that the MySQL Process on my nagios server is eating
up the cpu's and I am thinking about to test it with a postgresql.
I am not a DB engenieer so please don't ask about my config params like
different kind of tunings
Regards
Hendrik
--------------ms020502030009030901050801
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
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFuDCC
AtgwggJBoAMCAQICCQCm2uXMgNJKLDANBgkqhkiG9w0BAQUFADBPMQswCQYDVQQGEwJERTEM
MAoGA1UECBMDTlJXMRwwGgYDVQQKExNCYWVja2VyIElUIFNlcnZpY2VzMRQwEgYDVQQDEwtp
bnRlcm5hbCBDQTAeFw0wNzA4MDgxMzExMThaFw0wODA4MDcxMzExMThaMHsxCzAJBgNVBAYT
AkRFMQwwCgYDVQQIEwNOUlcxHDAaBgNVBAoTE0JhZWNrZXIgSVQgU2VydmljZXMxGDAWBgNV
BAMTD0hlbmRyaWsgQmFlY2tlcjEmMCQGCSqGSIb3DQEJARYXYW5kdXJpbkBwcm9jZXNzLXpl
cm8uZGUwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAJ9MdGOUbOUVjqr6sVAmSmwM4pl4
RCpOhRkLcZsxqS01xSdtsk60O9zKTNIM23A05WTECJwQL9jtdf2yjEpRrdBlwXGnU+muYZX7
L64RrdjqCRRdNqUlaM1YBRFTGKLSEjBfiF3B5SI6U19Gs4JdVH/Tnq9F/VmL7wPTBPT6HQfH
AgMBAAGjgY8wgYwwCQYDVR0TBAIwADARBglghkgBhvhCAQEEBAMCBaAwLAYJYIZIAYb4QgEN
BB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmljYXRlMB0GA1UdDgQWBBQeM6m5375Z0mi+
4fR2vjs/33lYVzAfBgNVHSMEGDAWgBS3rNDUwCvH3HcY6lNfn7uOxsWp4DANBgkqhkiG9w0B
AQUFAAOBgQC/NdkSRFIVzD21pqbGnX3NpG0l77QI5/GUraeWTiAUI1MCb+coUg7ySWqRwYl3
lVyrRY8vpf45xNib8LncgzoP4M6/T/YUWeYv+YIzrePEJS0oEUIwJcKTsdflVzoeiUipa64r
G2xpp/pln+zcRK75elz0ELKlp5YMc0IJpwXAMDCCAtgwggJBoAMCAQICCQCm2uXMgNJKLDAN
BgkqhkiG9w0BAQUFADBPMQswCQYDVQQGEwJERTEMMAoGA1UECBMDTlJXMRwwGgYDVQQKExNC
YWVja2VyIElUIFNlcnZpY2VzMRQwEgYDVQQDEwtpbnRlcm5hbCBDQTAeFw0wNzA4MDgxMzEx
MThaFw0wODA4MDcxMzExMThaMHsxCzAJBgNVBAYTAkRFMQwwCgYDVQQIEwNOUlcxHDAaBgNV
BAoTE0JhZWNrZXIgSVQgU2VydmljZXMxGDAWBgNVBAMTD0hlbmRyaWsgQmFlY2tlcjEmMCQG
CSqGSIb3DQEJARYXYW5kdXJpbkBwcm9jZXNzLXplcm8uZGUwgZ8wDQYJKoZIhvcNAQEBBQAD
gY0AMIGJAoGBAJ9MdGOUbOUVjqr6sVAmSmwM4pl4RCpOhRkLcZsxqS01xSdtsk60O9zKTNIM
23A05WTECJwQL9jtdf2yjEpRrdBlwXGnU+muYZX7L64RrdjqCRRdNqUlaM1YBRFTGKLSEjBf
iF3B5SI6U19Gs4JdVH/Tnq9F/VmL7wPTBPT6HQfHAgMBAAGjgY8wgYwwCQYDVR0TBAIwADAR
BglghkgBhvhCAQEEBAMCBaAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENl
cnRpZmljYXRlMB0GA1UdDgQWBBQeM6m5375Z0mi+4fR2vjs/33lYVzAfBgNVHSMEGDAWgBS3
rNDUwCvH3HcY6lNfn7uOxsWp4DANBgkqhkiG9w0BAQUFAAOBgQC/NdkSRFIVzD21pqbGnX3N
pG0l77QI5/GUraeWTiAUI1MCb+coUg7ySWqRwYl3lVyrRY8vpf45xNib8LncgzoP4M6/T/YU
WeYv+YIzrePEJS0oEUIwJcKTsdflVzoeiUipa64rG2xpp/pln+zcRK75elz0ELKlp5YMc0IJ
pwXAMDGCApMwggKPAgEBMFwwTzELMAkGA1UEBhMCREUxDDAKBgNVBAgTA05SVzEcMBoGA1UE
ChMTQmFlY2tlciBJVCBTZXJ2aWNlczEUMBIGA1UEAxMLaW50ZXJuYWwgQ0ECCQCm2uXMgNJK
LDAJBgUrDgMCGgUAoIIBjTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJ
BTEPFw0wNzA4MjAxNTI1MDNaMCMGCSqGSIb3DQEJBDEWBBSTLVr2vg/1BLEbPUTZlcsJNoND
yjBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG
9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDBrBgkrBgEEAYI3EAQxXjBcME8xCzAJ
BgNVBAYTAkRFMQwwCgYDVQQIEwNOUlcxHDAaBgNVBAoTE0JhZWNrZXIgSVQgU2VydmljZXMx
FDASBgNVBAMTC2ludGVybmFsIENBAgkAptrlzIDSSiwwbQYLKoZIhvcNAQkQAgsxXqBcME8x
CzAJBgNVBAYTAkRFMQwwCgYDVQQIEwNOUlcxHDAaBgNVBAoTE0JhZWNrZXIgSVQgU2Vydmlj
ZXMxFDASBgNVBAMTC2ludGVybmFsIENBAgkAptrlzIDSSiwwDQYJKoZIhvcNAQEBBQAEgYBK
imKuhs+7kai3IhHkTvGpnr7Sjf7neZ9BMS7w
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]